thisquery=select \ table1.column1, \ table1.column2, \ table1.column3 alternate_title, \ table1.column4 \ from \ table1 \ where \ #### perl -pi -e 's/select(.*?)table1\.column3(.*?)from/select\1DUMMY_ID\2from/sg' select.sql