/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 vote98 views3 answers
Fetlife
SQL
6 votes99 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
2 votes116 views1 answer
Mysql select true or false
SQL
0 vote111 views1 answer
How to check rollback status in oracle
SQL
2 votes87 views1 answer
Mysql auto increment jumping
SQL
0 vote107 views1 answer
Mysql backup certain tables workbench
SQL
8 votes142 views2 answers
Default sql server port
SQL
22 votes107 views3 answers
How to join three tables in sql using joins
SQL
0 vote93 views1 answer
Clone table structure mysql
SQL
1 vote106 views2 answers
Snowflake alter column data type
SQL