Unknown column

[The Little Guy]

SELECT *, a.answer as ans,COUNT(*) as total 
FROM phrases p 
LEFT JOIN answers a 
ON(p.id = a.phrase) 
WHERE p.id = 1 
AND total > 1 
GROUP BY a.answer 
ORDER BY total DESC

 

With the above I am getting an error saying: Unknown column 'total' in 'where clause'

This column is created, it holds a count, how can I only get results where the count (a.k.a. total) is larger than 1?

[The Little Guy]

got it. Had to use a HAVING clause:

 

SELECT *, a.answer as ans, COUNT(a.answer) as total
FROM phrases p 
LEFT JOIN answers a 
ON(p.id = a.phrase) 
WHERE p.id = 1 
GROUP BY a.answer HAVING total > 1
ORDER BY total DESC