Answers for "mysql concat two columns as one column and search"

SQL
2

mysql concatenate two columns into one

SELECT concat(first_column, ' ', second_column) from table_name
Posted by: Guest on February-22-2021
0

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
Posted by: Guest on May-04-2021

Code answers related to "mysql concat two columns as one column and search"

Code answers related to "SQL"

Browse Popular Code Answers by Language