Answers for "mysql row to column concat"

4

mysql concatenate columns

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

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

Browse Popular Code Answers by Language