Re: Small regex help?
| From: | Justin Patrin | Date: | Thu, 13 Oct 2005 03:27:04 +0000 |
| Subject: | Re: Small regex help? | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-21425@lists.php.net to get a copy of this message | ||
On 10/12/05, Guy Brom <guybrom@gmail.com> wrote:
> 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
>
/SELECT (.*?) FROM (.*?) ORDER BY .*/
replaced with
SELECT COUNT(*) FROM $1
--
Justin Patrin