怎么实现模糊查询含%的数据

Question

RT

Answer 1

select * from table名 where column1 like '123%';

Answer 2

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>

Answer 3

select * from tablename where fieldname like '%\%%';

Answer 4

用\转义即可
select * from tt where f1 like '\%%'