/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

1 vote157 views1 answer
Mysql search like order by best match
SQL
2 votes140 views1 answer
Oracle list duplicates
SQL
11 votes209 views5 answers
Update table from another table mysql
SQL
0 vote147 views1 answer
Count number of entires by months sql
SQL
-1 vote149 views1 answer
Mysql change database charset and collation
SQL
0 vote136 views1 answer
Print boolean in plsql
SQL
0 vote91 views1 answer
Microsoft sql server management studio clear cache
SQL
-1 vote155 views1 answer
Pl sql drop trigger
SQL
0 vote130 views1 answer
Update having mysql
SQL
0 vote132 views1 answer
Sql gather statistics to increase performance
SQL