/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

2 votes142 views1 answer
How to find table table in stored procedure sql server
SQL
1 vote127 views1 answer
Drush sql-dump
SQL
1 vote126 views1 answer
Hexadec to sql REDSHIFT
SQL
2 votes131 views1 answer
Oracle virtual column
SQL
1 vote138 views1 answer
Mysql find most common value
SQL
0 vote133 views2 answers
Sql query inner join 3 tables
SQL
1 vote129 views1 answer
Oracle first row
SQL
0 vote127 views1 answer
Sql character index
SQL
3 votes147 views2 answers
How to force truncate a table in mysql
SQL
1 vote154 views1 answer
Postgresql not in
SQL