/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 vote291 views1 answer
Copy value from one column to another postgres
SQL
0 vote233 views1 answer
Check if due date is less than todays date sql
SQL
0 vote273 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
0 vote299 views1 answer
Show the colums of table sql
SQL
0 vote275 views1 answer
How to print out column name differently in mysql
SQL
0 vote293 views1 answer
Run mysql xampp shell
SQL
1 vote289 views1 answer
Postgresql delete cascade
SQL
7 votes311 views2 answers
MySQL IF without else
SQL
5 votes314 views3 answers
Sql server utc to local
SQL
0 vote284 views1 answer
Show size of all tables postgres
SQL