/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 vote258 views1 answer
How to use query in nosql
SQL
0 vote303 views1 answer
Mysql get nth highest
SQL
4 votes294 views1 answer
Sql delete multiple conditions
SQL
2 votes276 views3 answers
Postgres create view
SQL
0 vote287 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote294 views1 answer
Implode in sql query
SQL
0 vote291 views1 answer
Move table to a different schema
SQL
2 votes272 views1 answer
Mysql application.properties spring boot
SQL
0 vote290 views1 answer
Postgresql stored procedure update table values
SQL
0 vote282 views1 answer
Connect by query in oracle
SQL