area表
id | areaname |
25 | 云南省 |
417 | 玉溪市 |
要求:在area表中根据id查出两条数据,将这两条数据用"-"拼起来
如下:
areaname |
云南省-玉溪市 |
mysql语句:
select group_concat(name Separator '-') as areaname from
(select b.name as name from area b.id=25 UNION select d.name as name from area d where d.id=417) c