模糊查询

/*%任意个任意字符模糊匹配*/
select * from tb_catalog_domain t where t.ymc like '%信息'
select * from tb_catalog_domain t where t.ymc like '体弱%'
select * from tb_catalog_domain t where t.ymc like '%体%'

/*_单字符模糊匹配*/
select * from tb_catalog_domain t where t.ymc like '%体_'
select * from tb_catalog_domain t where t.jc like '体_'
select * from tb_catalog_domain t where t.ymc like '__体_'

/*离散值匹配*/
select * from user where u_name like '[张李王]三'
/*找出：张三，李三，王三*/

/*部分有序模糊匹配*/
SELECT * FROM [user] WHERE u_name LIKE '老[1-9]'
/*找出：老1，老2，...老9*/
SELECT * FROM [user] WHERE u_name LIKE 'a[a-e]'
/*找出：aa，ab，...ae*/

/*部分有序去模糊匹配*/
SELECT * FROM [user] WHERE u_name LIKE '老[^1-3]'
/*找出u_name不是老1，老2，老3的记录*/
SELECT * FROM [user] WHERE u_name LIKE 'a[^abe]'
/*找出u_name不是aa，ab,ae*/