5 Useful MySQL Functions And Control Flows
View Single Post
12-09-2007, 04:42 PM
Join Date: Dec 2007
Originally Posted by
Last but not least,
can be used in MySQL in place of the more primitive
. It uses the standard PCRE syntax.
MySQL uses Henry Spencer's implementation of regular expressions, which is aimed at conformance with POSIX 1003.2.
Just for the record, that's another regex flavor than PCRE. I believe it's the same as the
PHP ereg functions
Word boundary metacharacters, for example, are not
Also I believe POSIX keeps on searching for the longest match, whereas PCRE returns the first found match. Sounds a bit vague probably, anyway, my point is that MySQL's REGEXP and PCRE are not the same.
- PHP5 framework
View Public Profile
Send a private message to Geert
Visit Geert's homepage!
Find More Posts by Geert