You are not logged in.
Pages: 1
Does anyone know if it's possible to use a column you've selected in other functions in your select statement? I am using the following query at the minute:
select title, ifnull(filtered,title) as filtered_title, left(ifnull(filtered,title),1) as first_char, count(*) as count from movie as m left join movie_filtered as mf on m.id=mf.id group by left(ifnull(filtered,title),1)
I was hoping to use the `filtered_title` column value in the group by parameter and also to the left function. Any ideas would be fantastic.
Offline
Why don't you just create a new variable containing the filtered_title column value, before this statement?
Offline
Pages: 1