where 子句中使用通配符

模糊匹配

 

------------------------模糊匹配-----------------

• '[1-9]'、'[a-z]'、'[^4]'

select * from student where pwd like '[0-9]%'
select * from student where pwd like '[^a-z]%'
select * from student where pwd like '[4]%'

• between  ... and ...

select * from student where stuno between  00000002 and 00000008

• 列名=值

select * from student where stuno=00000002

• in(值,值,值,值)

select * from student where stuno in(00000009,00000005,00000002)

 ----------------------------------------------------------------------------------