模糊查询
来源：互联网 发布：大数据 重庆 编辑：程序博客网 时间：2024/05/15 07:38
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]_'
