1、对"%"的转义
select * from student where description like '%!%%' escape '!'
本sql解释为取出表student中所有字段description中含有"%"的记录。
2、对"_"的转义
select * from students where description like '%!_%' escape '!'
本sql解释为取出表student中所有字段description中含有"_"的记录。
3、对"'"的转义
select * from students where description like '%''%''