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 '%''%''
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 '%''%''
扫一扫
598
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
