[RESOLVED] How to merger multi rows as one in mysql

use table "mysql" for example:

SELECT
user.host
FROM user

the is result such as:
host1
host2
host3

with sql ,how could I merger these rows in one filed(as a string implode width ',' or other else), such as:
host1,host2,host3

Did u try subselect or union?

It's probably possible, but this kind of thing really is easier to do with PHP.

MYSQL > 4.1

SELECT GROUP_CONCAT(u.host SEPARATOR ',') AS imploded_hosts FROM user u GROUP BY u.id

NuLL[PL] wrote:

MYSQL > 4.1

SELECT GROUP_CONCAT(u.host SEPARATOR ',') AS imploded_hosts FROM user u GROUP BY u.id

That's it!

Thanks very much.

Thanks all of you paid attention.

sorry,the unit-test is too simple,so what about this situation :

SELECT
count(user.host) as host_count
,user.host
FROM user
GROUP BY
user.host
ORDER BY host_count desc

the result such as:
host_count,host
3,host1
2,host3
1,host2

the "ORDER BY host_count desc" is needed,and just need to return "host1,host3,host2",
what should I do then ?