How to do a LIKE considering two columns?

mysql sql concatenation sql-like
RedDragon picture RedDragon · Aug 11, 2011 · Viewed 13k times · Source

I have a customer table with two columns first_name and last_name.

How can I use LIKE in a query being able to get data from both columns at same tame?

For instance:

SELECT CONCAT(first_name, ' ', last_name) as 'full_name' 
FROM customer WHERE full_name LIKE 'John D%'

I've tried this and it tells me full_name column doesn't exist.

Answer

Ned Batchelder picture Ned Batchelder · Aug 11, 2011 
SELECT CONCAT(first_name, ' ', last_name) as 'full_name' 
FROM customer WHERE CONCAT(first_name, ' ', last_name) LIKE 'John D%'

Related questions

SQL UPDATE all values in a field with appended string CONCAT not working

Here is what I want to do: current table: +----+-------------+ | id | data | +----+-------------+ | 1 | max | | 2 | linda | | 3 | sam | | 4 | henry | +----+-------------+ Mystery Query ( something like "UPDATE table SET data = CONCAT(data, 'a')" ) resulting table: +----+-------------+ | id | data | +----+-------------+ | 1 | …

Read More
How to use GROUP BY to concatenate strings in MySQL?

Basically the question is how to get from this: foo_id foo_name 1 A 1 B 2 C to this: foo_id foo_name 1 A B 2 C

Read More
MySQL Results as comma separated list

I need to run a query like: SELECT p.id, p.name, (SELECT name FROM sites s WHERE s.id = p.site_id) AS site_list FROM publications p But I'd like the sub-select to return a comma separated list, …

Read More