模糊查询(like的使用)
例:
查询name字段中含有数字的:</span>
select * from table1 where name like ‘%[0-9]%’ </span>
查询name字段中含有小写字母的:</span>
select * from table1 where name like ‘%[a-z]%</span>
查询name字段中不含有数字的</span>
select * from table1 where name like ‘%[!0-9]%’ 补充一点,?或者_表示单个字符</span>
</pre><pre>