/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 vote198 views1 answer
What is a Database?
SQL
0 vote199 views1 answer
Will graphql replace sql
SQL
0 vote208 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote204 views1 answer
Oracle select partition
SQL
10 votes199 views2 answers
Mysql alter add foreign key
SQL
0 vote213 views1 answer
Pagination with row_number
SQL
0 vote272 views1 answer
Merge clause with inner join
SQL
3 votes205 views1 answer
Oracle user privileges
SQL
0 vote190 views1 answer
Get week day name sql server
SQL
0 vote235 views1 answer
Where date in datetime mysql
SQL