mysql concat rows code example

Example 1: mysql concatenate select results

SELECT person_id, GROUP_CONCAT(hobbies SEPARATOR ', ')
FROM peoples_hobbies
GROUP BY person_id;

Example 2: concat in mysql

CONCAT (string1, string2,…)