/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 vote233 views1 answer
Get create sql of hibernqte entity
SQL
2 votes199 views1 answer
How to insert string variable into sqlite database
SQL
0 vote231 views1 answer
Sparql if bound query
SQL
0 vote195 views1 answer
Create database store
SQL
0 vote202 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote207 views1 answer
Rabbitmq ui not working
SQL
6 votes282 views3 answers
Rename column ORACLE
SQL
0 vote202 views1 answer
Restore backup mysql .gz
SQL
1 vote175 views1 answer
Table infromation in sql server
SQL
0 vote185 views1 answer
Restore backup "text" postgresql command line
SQL