Answers for "mysql concatenate"

mysql concatenate columns

SELECT CONCAT(first_name, ' ', last_name) AS 'Name', dept FROM users;

Posted by: Guest on July-23-2021

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

mysql concat and use as where column

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

Posted by: Guest on November-04-2020

Code answers related to "mysql concatenate"