Hello !!
I'd like to filter my data with a Regular Expression in mysql but when I run the script I get Syntax error: Encountered " "REGEXP "" at line 4, column 21. Was expecting: .
My query: SELECT * FROM fichier WHERE code_insee_commune REGEXP "^(2[ab]|0[1-9]|[1-9][0-9])[0-9]{3}$"
Is the problem with my query ? regular expressions are not supported ?
Do you have other alternatives ?
Thank you