/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 vote186 views1 answer
What is logical database schema
SQL
2 votes181 views1 answer
Mysql application.properties spring boot
SQL
0 vote197 views1 answer
Tsql delete all rows
SQL
0 vote173 views2 answers
SQL FROM
SQL
0 vote177 views1 answer
Mysql shell set time_zone
SQL
10 votes185 views6 answers
Sql between
SQL
0 vote183 views1 answer
How to select an index in oracle sql
SQL
12 votes214 views6 answers
Change mysql root password
SQL
0 vote189 views1 answer
Oracle query archive mode
SQL
1 vote187 views1 answer
Mysql backup skip table
SQL