JasonC Posted August 23, 2012 Share Posted August 23, 2012 I'm just trying to use an alias in a select query and I'm having a problem. It's not a big deal, but I don't know why I'm getting an error. Can anyone answer this: Why does SELECT title, text, id FROM memos LEFT JOIN memos_associations USING (id) WHERE CONCAT_WS(' ',title,text) REGEXP '[[:<:]]potassium[[:>:]]' = 1 work ok, but SELECT title, text, id, CONCAT_WS(' ',title,text) AS combo FROM memos LEFT JOIN memos_associations USING (id) WHERE combo REGEXP '[[:<:]]potassium[[:>:]]' = 1 not? The latter generates the error, "ERROR 1054 (42S22): Unknown column 'combo' in 'where clause'." Thanks! ...Jason Link to comment Share on other sites More sharing options...
JasonC Posted August 23, 2012 Author Share Posted August 23, 2012 Found the answer, I guess, at http://stackoverflow.com/questions/153598/unknown-column-in-where-clause Link to comment Share on other sites More sharing options...
Recommended Posts