concat in mysql of different column code example
Example 1: mysql concatenate two columns into one
SELECT concat(first_column, ' ', second_column) from table_name
Example 2: mysql concat and use as where column
select * from table where concat_ws(' ',first_name,last_name)
like '%$search_term%';