/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

1 vote72 views1 answer
Unique vs distinct sql
SQL
0 vote122 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
0 vote125 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote120 views1 answer
Sql server select ignore dupplicates
SQL
2 votes118 views1 answer
Mysql last 7 days including today
SQL
0 vote128 views1 answer
How to check database engine in mysql
SQL
2 votes115 views1 answer
Oracle drop sequence if exists
SQL
0 vote118 views1 answer
Difference between varchar and varchar2
SQL
0 vote117 views1 answer
Update set with inner join oracle
SQL
0 vote157 views2 answers
Create more than 1 tables with references to each other in sqlite3
SQL