/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

11 votes385 views1 answer
Oracle view source
SQL
0 vote385 views1 answer
C# mysql data reader from two tables
SQL
2 votes351 views1 answer
Sql server find table name
SQL
3 votes450 views4 answers
Sql interview questions
SQL
1 vote410 views1 answer
Encrypt password postgresql
SQL
0 vote338 views1 answer
Oracle sqlp update amount / quantity
SQL
2 votes351 views1 answer
Create table with primary key
SQL
0 vote364 views1 answer
How to to get current date in sql
SQL
0 vote391 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
6 votes340 views1 answer
Sqlite foreign key
SQL