Select * from user where user_age in (12,13)
Select * from user where user_name IN ('mary','harry')
选取两个值之间的数据
查询年龄在12和14之间的数据
Select * from user where user_age between 12 and 14
查询字母在Alice和John之间的数据
Select * from user where user_name between 'alice' AND'john'
希望能对大家有所帮助。