Re: Small regex help?
| From: | Ethilien | Date: | Thu, 13 Oct 2005 03:43:56 +0000 |
| Subject: | Re: Small regex help? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-224013@lists.php.net to get a copy of this message | ||
Hmmm,
"/SELECT .* FROM (.*) WHERE (.*) ORDER BY .*/Ui", "SELECT count(*) FROM \$1 WHERE \$2"
Might work, but haven't tried it...
Guy Brom 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 Thanks!