Jump to content
Larry Ullman's Book Forums

Where'S The Alias Error In This Mysql Phrase


Recommended Posts

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

 Share

×
×
  • Create New...