In the query below, I've escaped the + characters so that they will not be interpreted as a meta character. But they are being seen as a meta.
MySQL is catching the + chars and giving me an error.
What's going on? Please let me know. I'm a bit baffled here. Bug?
-------------------------------------------------------------
Error
SQL-query:
SELECT * FROM skill WHERE UPPER(name) REGEXP '^C\+\+$|^C\+\+ .|. C\+\+$'
MySQL said: Got error 'repetition-operator operand invalid' from regexp
---------------------------------------------------------------------
MySQL is catching the + chars and giving me an error.
What's going on? Please let me know. I'm a bit baffled here. Bug?
-------------------------------------------------------------
Error
SQL-query:
SELECT * FROM skill WHERE UPPER(name) REGEXP '^C\+\+$|^C\+\+ .|. C\+\+$'
MySQL said: Got error 'repetition-operator operand invalid' from regexp
---------------------------------------------------------------------