PHP / MySQL - 在一列中返回值[关闭]

Question

I need to select same values in 1 column, for example: Select * from Table, this needs to return like this:

ColumnName | ColumnValue
google         1,2,3,4
facebook       1,2,3,5

The actual query, returns this.

ColumnName | ColumnValue
google           1
google           2
google           3
google           4
facebook         1
facebook         2
facebook         3
facebook         4

Can someone help me?

Thanks!

Answer 1

You're looking for GROUP_CONCAT:

SELECT GROUP_CONCAT(ColumnValue SEPARATOR ', ') FROM table GROUP BY ColumnName;

Considering the reasoning behind relational databases though, you should be cautious about purposely denormalizing your results.