Hello, I am currently trying to create a SQL query with regular expressions. However, I didn’t find any way to escape parentheses that are a part of the query.
SELECT * FROM tablename WHERE something REGEXP 'regulartext([0-9]+) \\(parenthesis'
When I try to execute this, I get the following error:
“#1139 - Got error ‘parentheses not balanced’ from regexp”
My query will be a bit more complicated than the example above, but I can’t find a way to escape the parantheses - so an entry containing “regulartext8 (paranthesis” will be matched. How can I do that?