mysql select concatenate column values code example

Example 1: mysql concatenate select results

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

Example 2: mysql concat and use as where column

select * from table where concat_ws(' ',first_name,last_name) 
like '%$search_term%';