SQL实现模糊查询的四种方法小结

//查问一切姓名包括“弛”的记实
select * from student where name like '弛'

//盘问一切姓名蕴含“弛”，地点包罗四川的记实
select * from student where name like '弛' and address like '四川'
//查问一切姓名包罗“弛”，或者者所在包罗四川的记实
select * from student where name like '弛' or address like '四川'

//盘问一切名字姓弛，字少2个字的记载
select * from student where name like '弛_'
//盘问一切名字姓弛，字少三个字的纪录
select * from student where name like '弛__'

//盘问一切名字姓弛,字少没有限的纪录
select * from student where name like '弛%'
//查问一切名字姓弛，字少二个字的纪录
select * from student where name like '弛%'and len(name) = 两

//查问一切名字姓弛，第2个为数字，第三个为燕的纪录
select * from student where name like '弛[0-9]燕'
//查问一切名字姓弛，第2个为字母，第三个为燕的纪录
select * from student where name like '弛[a-z]燕'
//盘问一切名字姓弛，中央为1个字母或者1个数字，第三个为燕的名字。字母巨细写否以经由过程约束设定，没有分辨巨细写
select * from student where name like '弛[0-9a-z]燕'
//盘问一切名字姓弛，第2个没有为数字，第三个为燕的记载
select * from student where name like '弛[!0-9]燕' 
//盘问名字除了了伸开头妹末端中央是数字的记实
select * from student where name not like '弛[0-9]燕'

//盘问姓名包括通配符%的纪录
 select * from student where name like '%[%]%'                //经由过程[]本义
//盘问姓名蕴含[的记载
 select * from student where name like '%/[%' escape '/'    //经由过程指定'/'本义
//查问姓名包括通配符[]的记载
 select * from student where name like '%/[/]%' escape '/'    //经由过程指定'/'本义