php - group_concat MYSQL new line

Question

group_concat(A,' ',B,' ',C) as Name,

then using this php for displaying

<td><?php echo $row['Name']; ?></td>

using this query returns Name X,Y

but i prefer to have the names not comma separated rather line break X then Y new line

Any idea?

Answer 1

For MySQL (or plain text) output You could use as a separator:

SELECT GROUP_CONCAT(column1 SEPARATOR '
') FROM table1;

I use this very often when I need to get many new-line-separated values in one row for other processing.