|Syntactic Confectionery Delight|
Any way to use "POSIX Extended Regular Expressions"?by Lightknight (Beadle)
|on May 21, 2010 at 10:13 UTC||Need Help??|
Lightknight has asked for the
wisdom of the Perl Monks concerning the following question:
I need some regexps to match consistently in perl and MySQL.
MySQL doesn't use Perl compatible regular expressions but "MySQL uses Henry Spencer's implementation of regular expressions".
And there is a way to use Perl compatible regular expressions in MySQL but that requires modification of the MySQL server, and I'd like to avoid that. I'm surprised I can't find a way (even on CPAN?) to use exactly "POSIX Extended Regular Expressions" in perl. (Which is not the same as /foo/x)
Am I missing something obvious? Is there a way to match against "POSIX Extended Regular Expressions" in perl?