mysql concat string with column value code example

Example 1: concat in mysql

CONCAT (string1, string2,…)

Example 2: mysql concat and use as where column

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