sql 多个条件查询

diyao5994

于 2016-09-14 10:36:00 发布

阅读量405

点赞数

原文链接：http://www.cnblogs.com/qulinke/articles/5870984.html

版权

sql 多个条件查询

1 SELECT GROUP_CONCAT(region_name SEPARATOR "|" ) FROM zcg_region as a WHERE region_id IN(16,174,1841);
2     
3 
4 SELECT CONCAT(a.region_name,',',b.region_name,',',c.region_name) as region_name FROM  zcg_region as a , zcg_region as b , zcg_region as c 
5 
6 WHERE a.region_id=16 and b.region_id=174 and c.region_id=1841

转载于:https://www.cnblogs.com/qulinke/articles/5870984.html