mysql concat two columns code example

Example 1: mysql concatenate two columns into one

SELECT concat(first_column, ' ', second_column) from table_name

Example 2: mysql all columns

-- MySQL
SELECT * 
FROM INFORMATION_SCHEMA.COLUMNS;

Example 3: concat in mysql

CONCAT (string1, string2,…)

Example 4: mysql concat and use as where column

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