sql 多个条件查询

 
  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

 

posted @ 2016-09-14 10:36  飞越全球  阅读(5599)  评论(0)  编辑  收藏  举报