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?