Hi

I want to check the existance of a question mark (?) within `field1`
Code:
SELECT *
FROM `tbl1`
WHERE `field1` REGEXP 'pattern1\?pattern2'
On removing \? the query works but with it I get :
#1139 - Got error 'repetition-operator operand invalid' from regexp
I escaped the ? with backslash but still I get this error.
How is that ?

Thanks

MySQL 5.0.22