Posted by "Guy Brom" on 10/13/05 05:29

Can anyone suggest the correct regex to replace col1,col2... with count(*)
and strip out everything just before ORDER BY?

so for this:
SELECT col1,col2... FROM tbl WHERE filter1 filter2 ORDER BY order1,order2

I would get this:
SELECT count(*) FROM tbl WHERE filter1 filter2

Thanks!

• Next in forum: Re: [PHP] storing passwords in $_SESSION
• Prev in forum: Re: [PHP] Any good free easy converting tool?
• Thread view: Small regex help?

[Reply to this message]