/SQL/Combine 2 columns search query mysql

Combine 2 columns search query mysql

Select Contacts.*, Contacts.ID as CID 
from Contacts 
left join website_Data 
on Contacts.ID = website_Data.ContactID 
where CONCAT(Contacts.FirstName,' ', Contacts.LastName) LIKE '%Illusion Softwares%' 
order by Contacts.`Created` DESC

Source: stackoverflow.com

Similar codes

0 vote135 views1 answer
Group by max date
SQL
0 vote184 views1 answer
Postgres rename database
SQL
0 vote167 views1 answer
Postgresql find biggest table
SQL
0 vote136 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote146 views1 answer
Space not removing from column in sql
SQL
0 vote123 views1 answer
Codeigniter 3 get best-selling products
SQL
-1 vote143 views1 answer
Ms sql select datetime as date
SQL
1 vote146 views1 answer
OSError: mysql_config not found
SQL
1 vote115 views1 answer
Round function in sql oracle
SQL
0 vote130 views1 answer
Replace \n sql
SQL