group_concat MYSQL new line

advertisements
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?


I don't understand what do you mean by line break between X and Y, but if you don'e need comma separated you can Add any separator to the Group_Concat like that:

group_concat(Name SEPARATOR ' ') as Name

and here is Some other Separators you can use.