Posted by Philip Hallstrom on 10/13/05 07:01

> 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

$str = "SELECT col1,col2... FROM tbl WHERE filter1 filter2 ORDER BY order1,order2";

$str = ereg_replace("^SELECT .* FROM (.*) ORDER BY .*",
"SELECT COUNT(*) FROM \\1", $str);

• Next in forum: Is DOM the right thing for the job?
• Prev in forum: Re: Small regex help?
• Thread view: Re: [PHP] Small regex help?

[Reply to this message]