IN:
只要数据满足in里面的一个条件就可以了
找到user_age是12或者13的数据
Select * from user where user_age in (12,13)
找到user_name是Harry和Mary的数据
Select * from user where user_name IN ('mary','harry')
Between and:
选取两个值之间的数据
查询年龄在12和14之间的数据
Select * from user where user_age between 12 and 14
查询字母在Alice和John之间的数据
Select * from user where user_name between 'alice' AND'john'
希望能对大家有所帮助。
