Re: Small regex help?
| From: | Philip Hallstrom | Date: | Thu, 13 Oct 2005 04:01:40 +0000 |
| Subject: | Re: Small regex help? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-224012@lists.php.net to get a copy of this message | ||
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);