Hello,
Could someone help me with a regular expression in MySQL?
If I test the following pattern in PHP:
\b(\')?((eau){1}|(eaux){1})\b
the results are fine since I get a match for
but no match for
Yet if I try the very same pattern in the database, using phpMyAdmin, I get no results at all although all the above examples are in the database.
Could someone explain why this is happening, and what I need to do in MySQL?
In case you wonder why I'm not using a FULLTEXT search, I plan to use regular expressions for words that are 1, 2 or 3 characters long, and a FULLTEXT search for longer words or expressions.
With thanks for your help,