SQL-模糊查询

select * from tblstudent
--查询的是以张开头的所有的名字
select * from tblstudent where TSName like '张%'
--查询的是以张开头的名字，只有两个字
select * from tblstudent where TSName like '张_'
--查询的是以张开头的名字，三个字
select * from TblStudent where tSName like '张%' and LEN(tSName)=3
--第二种
select * from tblstudent where TSName like '张__'
查询以张开头的名字中有字母的,三个字
select * from TblStudent where tSName like '张[a-z]%'

select * from TblStudent where TSName like '%张%'

select * from TblStudent where TSName like '张[%]%'

select * from TblStudent where tSName like '张[0-9]_'

select * from TblStudent where tSName like '张[^0-9]_'