查询表中字段包含%的记录

[feiyun1987]

网上的答案很多
例:select * from cq_action r1 like '%\%%';
还有就是:
select * from cq_action r1 like '[%]';
大家告诉我一下哪个是对的吧

[wwwwb]

like '%\%%';
用转义

[chinajnt]

select * from site where title like '%\%%';

[懒得去死]

select * from test where txt like '%\%%';
OR
select * from test where txt rlike '^.*%.*$';

[miaozhendeduwu]

select * from cq_action r1 like '%\%%';

select * from cq_action r1 like '%';
模糊查詢，在加上匹配的字符。