怎么查找带英文中的"?"的字符串??????????????

[outred2000]

怎么查找英文中带"?"的字符串；
比如：我要查找一个table表中字段str的内容包含有"?"的所有记录出来，SQL如下：
select * from table where str regexp '?';
select * from table where str regexp '\?';
上面两条执行的结果均报错：
#1139 - Got error 'repetition-operator operand invalid' from regexp


正确的写法怎么写呢????????

[vinsonshen]

select * from table where locate('?','str')>0;

或

select * from table where instr('str','?')>0;

[vinsonshen]

select   *   from   table   where   locate( '? ', 'str ')> 0; 

或 

select   *   from   table   where   instr( 'str ', '? ')> 0;

[wwwwb]

SELECT * FROM bb WHERE mobile LIKE '%\?%'

[阿_布]

select * from t where name REGEXP '[^\\?]*\\?\\.*';

[ACMAIN_CHM]

select * from table where str regexp '\\?';

[ACMAIN_CHM]

mysql> select 'adf?adf' regexp '\\?';
+------------------------+
| 'adf?adf' regexp '\\?' |
+------------------------+
|                      1 |
+------------------------+
1 row in set (0.00 sec)

[nianzhang747]

regexp '\\?';

或者用like