/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 vote401 views1 answer
Why do we need data structure in sql
SQL
3 votes341 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote392 views1 answer
Pl sql join 3 tables
SQL
4 votes335 views3 answers
NOT NULL SQL
SQL
0 vote344 views1 answer
Sql server roles and users
SQL
1 vote330 views1 answer
Mysql change root mysql_native_password
SQL
3 votes331 views1 answer
Dbms_scheduler drop_job
SQL
3 votes333 views2 answers
Mysql create database
SQL
0 vote363 views1 answer
Sql missing values
SQL
0 vote342 views1 answer
Mysql shell ERROR: Not connected.
SQL