/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 vote162 views1 answer
Get last updated row sql server
SQL
0 vote163 views1 answer
Mysql remove bad character from all fields
SQL
0 vote145 views1 answer
Firebase sql
SQL
1 vote147 views1 answer
Customer using hdfc bank sql query
SQL
5 votes158 views1 answer
Oracle list packages
SQL
0 vote151 views1 answer
Resullt all update knex mysql
SQL
0 vote165 views3 answers
Mysql regex replace
SQL
0 vote159 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote142 views1 answer
Oracle sql winter time change
SQL
0 vote170 views3 answers
Join
SQL