Search code examples
mysqlsubquerymysql-error-1054sql-like

Subquery field in Like

I have the following query:

SELECT
(...),
(SELECT us.short FROM url_short us WHERE us.urlId = u.id
  ORDER BY us.id DESC LIMIT 1) as short, 
(...),
(SELECT f.name FROM `group` f LEFT JOIN group_url fu ON f.id = fu.group_id WHERE
  fu.url_id = u.id ORDER BY f.id DESC LIMIT 1) as f_name
FROM (...)
WHERE (...) AND
(u.url LIKE '%ops%'
OR short LIKE '%ops%'
OR u.url_name LIKE '%ops%'
OR f_name LIKE '%ops%')
(...)

However, when I try to use LIKE in short and f_group MySQL say me that:

#1054 - Unknown column 'short' in 'where clause'

I already search a lot and found nothing

Solution

  • You use alias in your query, and this probably causes this error. Here's another question with similar problem.