like操作符用于在where句子中搜索列中的指定模式语法：select column_name(s) from table_name where column_name like pattern;
语法：select * from persons where addr like ‘s%‘;注意：上面的%号就是一个通配符（模式中缺少的部分），只要第一个字母是s就可以
语法：select id,addr from persons where addr like ‘%j‘;
语法：select * from persons where addr like ‘%z%‘;
语法：select * from persons where addr not like ‘%z%‘;
原文：http://blog.csdn.net/lianghe_work/article/details/45042623
