/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 vote249 views1 answer
Automated psql csv export script on windows
SQL
2 votes211 views1 answer
Mysql id of inserted row
SQL
2 votes239 views1 answer
Sql get the name of user pc
SQL
0 vote169 views1 answer
Mysql timeout 30 seconds
SQL
0 vote252 views1 answer
Create a plsql object
SQL
0 vote286 views1 answer
Sql select rows between 1000 and 2000
SQL
11 votes225 views4 answers
Reset identity column values in sql server
SQL
0 vote227 views1 answer
Tsql pad left
SQL
-1 vote206 views1 answer
How to switch user in mysql
SQL
4 votes169 views2 answers
Select todays data postgres query
SQL