56,681
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
WWWWA 2009-12-17
- 打赏
- 举报
用\转义即可
select * from tt where f1 like '\%%'
select * from tt where f1 like '\%%'
lidanzi 2009-12-17
- 打赏
- 举报
谢谢 结贴
阿_布 2009-12-17
- 打赏
- 举报
select * from tablename where fieldname like '%\%%';
ACMAIN_CHM 2009-12-17
- 打赏
- 举报
mysql> select '123%123' like '123\%1%';
+--------------------------+
| '123%123' like '123\%1%' |
+--------------------------+
| 1 |
+--------------------------+
1 row in set (0.06 sec)
mysql> select '123%123' like '123\%2%';
+--------------------------+
| '123%123' like '123\%2%' |
+--------------------------+
| 0 |
+--------------------------+
1 row in set (0.00 sec)
mysql>
+--------------------------+
| '123%123' like '123\%1%' |
+--------------------------+
| 1 |
+--------------------------+
1 row in set (0.06 sec)
mysql> select '123%123' like '123\%2%';
+--------------------------+
| '123%123' like '123\%2%' |
+--------------------------+
| 0 |
+--------------------------+
1 row in set (0.00 sec)
mysql>
leoxqing 2009-12-17
- 打赏
- 举报
select * from table名 where column1 like '123%';
