group concat

Often database programmers need to concatenate multiple MySQL rows into one field. Here is how to do this using group_concat() function.