/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 vote158 views1 answer
Order by with where clause in mysql
SQL
0 vote165 views1 answer
Rabbitmq ui not working
SQL
0 vote169 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
0 vote191 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote160 views1 answer
How to get inserted id in sql server
SQL
0 vote159 views1 answer
Multiple left join mysql
SQL
0 vote178 views4 answers
How to get max salary in each department in sql
SQL
0 vote131 views0 answer
SQL
0 vote204 views1 answer
Doctors appointment
SQL
0 vote196 views1 answer
Select new table sql
SQL