Using Mysql Alias in WHERE

[webdev]

I am trying to execute the following query but I get unknown column for rating_score for the WHERE clause. Code: --------- SELECT SUM(ratings.rating_rating) AS rating_score, posts.ID, posts.post_title FROM posts LEFT JOIN ratings ON ratings.rating_postid = posts.ID WHERE rating_score >= 1...