Search Results

Hmm ... I still don't seem to be getting the required output ...

nawk 'BEGIN{RS=";"}{sub(/[Ff][Rr][Oo][Mm].*[Ww][Hh][Ee][Rr][Ee]/,"where",$0);gsub(/\012/,"",$0);printf("%s;\n",$0)}' test.sql
...

Thanx a lot ... yeah it does work ... but on some statements like these :

select * from test WHERE test_id in (select test_id1 from test1 where test_id1=1);

the output is :

select * where...

Hi,

I have a file which contains the following :

select * from test where test_id=1;

select id
from test1, test2 where test_id=1 and test_id=2;

select * from
test1, test2, test3 where...