/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 vote330 views1 answer
Postgresql isnull with max
SQL
0 vote285 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote306 views2 answers
How to combine two sql queries in one result
SQL
0 vote368 views2 answers
Mysql update two tables at once
SQL
1 vote345 views1 answer
Sql drop with dependencies
SQL
0 vote354 views1 answer
Sql server udf performance
SQL
0 vote334 views1 answer
Postgresql if else endif
SQL
4 votes354 views2 answers
Oracle unlock user
SQL
0 vote359 views1 answer
Flexible search query delete table
SQL
0 vote353 views2 answers
Starting mysql service from mac
SQL