MySQL select with CONCAT condition

by

The aliases you give are for the output of the query – they are not available within the query itself.

You can either repeat the expression:

SELECT neededfield, CONCAT(firstname, ' ', lastname) as firstlast 
FROM users
WHERE CONCAT(firstname, ' ', lastname) = "Bob Michael Jones"

or wrap the query

SELECT * FROM (
  SELECT neededfield, CONCAT(firstname, ' ', lastname) as firstlast 
  FROM users) base 
WHERE firstLast = "Bob Michael Jones"

More Related Contents:

  1. Recreating a query using INNER JOIN? [duplicate]
  2. How can I select data from different tables?
  3. Can I concatenate multiple MySQL rows into one field?
  4. Select all columns except one in MySQL?
  5. How to use GROUP_CONCAT in a CONCAT in MySQL
  6. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  7. MySQL Query – Records between Today and Last 30 Days
  8. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  9. What is MySQL row order for “SELECT * FROM table_name;”?
  10. Select mysql query between date?
  11. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  12. mysql select from n last rows
  13. Checking multiple columns for one value
  14. Sort by order of values in a select statement “in” clause in mysql
  15. MySQL – How to search for exact word match using LIKE?
  16. MySQL – How to select data by string length
  17. Return a default value if single row is not found
  18. MySQL – Select the last inserted row easiest way
  19. Sum results of a few queries and then find top 5 in SQL
  20. MySQL SELECT LIKE or REGEXP to match multiple words in one record
  21. Syntax error when using except in a query
  22. SELECT query return 1 row from each group
  23. SQL query to check if a name begins and ends with a vowel
  24. Using index, using temporary, using filesort – how to fix this?
  25. MySQL : retrieve a large select by chunks
  26. MySQL – insert data from another table merged with constants
  27. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  28. MySQL Error: #1142 – SELECT command denied to user
  29. How to SELECT by MAX(date)?
  30. MySQL matching unicode characters with ascii version

Leave a Comment