mysql数据库sql查询语句：多条件判断
1、创建测试表，
create table test_person(id int, RMB int);
2、插入测试数据
insert into test_person values(1,180);
insert into test_person values(2,170);
insert into test_person values(3,290);
insert into test_person values(4,160);
insert into test_person values(5,299);
insert into test_person values(6,266);
insert into test_person values(7,155);
3、查询表中所有记录，select t.* from test_person t，
4、编写sql，汇总每个vip类型的用户数，
select vip_type, count(distinct id)
from (select case when RMB>100 and RMB<200 then 'VIP1' when RMB>200 then 'VIP2' end as vip_type, id
from test_person) t
group by vip_type
mysq
条件里面不可以用函数。先处理数据将需要比较的两个字段的值修改成相同格式。
mysql动态多条件查询语句！！！！
select * from table where (name1 like '%key1%' or name2 like '%key2%' or name3 like '%key3%')
同理，你还可以任意再次组合，用or连接就行
如再上 name1 like key1 or name1 like key2 or name1 like key3
name2 like key1 or name2 like key2 or name2 like key3
等等
