concat mysql
snippet in sql

concat mysql

user535

CONCAT (string1, string2,…) AS column_name

concat in mysql

user9367

CONCAT (string1, string2,…)

mysql concat and use as where column

user7364

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