Sql concatenate columns

This article is tagged with: Sql concatenate columns and mysql

sql concatenate columns

SELECT CONCAT(Address, " ", PostalCode, " ", City) AS Address
FROM
Customers;

mysql concat and use as where column

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

This article is tagged with: Sql concatenate columns and mysql