mysql数据量sql 查询语句特殊字符转义

1，搜索a'b...

SELECT * FROM user WHERE name LIKE 'a\'b%'；
2，搜索a%b...

SELECT * FROM user WHERE name LIKE 'a\%b%';
3，搜索a_b...

SELECT * FROM user WHERE name LIKE 'a\_b%';
4，搜索a\b...

SELECT * FROM user WHERE name LIKE  'a\\\\b%';