Answers for "mysql concatenate string"

4

mysql concatenate columns

SELECT CONCAT(first_name, ' ', last_name) AS 'Name', dept FROM users;
Posted by: Guest on July-23-2021
0

mysql concatenate select results

SELECT person_id, GROUP_CONCAT(hobbies SEPARATOR ', ')
FROM peoples_hobbies
GROUP BY person_id;
Posted by: Guest on October-09-2020

Browse Popular Code Answers by Language