Sql

Search

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: drush run sql select
Sql :: postgres dump sql insert
Sql :: sql view talbe columns
Sql :: create table query in mysql
Sql :: select random sample sql
Sql :: htaccess allow index
Sql :: sql delete column
Sql :: get sum sqlite android
Sql :: mysql import from sql file
Sql :: how to delete all duplicate items in mysql
Sql :: get initials name in sql
Sql :: creating table in mysql
Sql :: mysql random
Sql :: show table mysql
Sql :: How to backup databases using psql
Sql :: mysql where length greater than
Sql :: mql5 datetime get hour
Sql :: mysql table schema
Sql :: convert columns to rows in sql server
Sql :: sql inserted
Sql :: if else in mysql stored procedure
Sql :: psql get last rows
Sql :: Expression number 1 of select list is not in group by clause
Sql :: postgres extract date from timestamp
Sql :: how to check which sp is running in sql server
Sql :: identity syntax in sql
Sql :: mysql updating multiple column values from array variable
Sql :: how to get the maximum length of a name in sql
Sql :: mysql insert rows to another database
Sql :: oracle undo tablespace list by user

Search

SQL

combine 2 columns search query mysql

ADD CONTENT