Ordering mysql rows from derived columns

Question

I wanted to retrieve rows from the mysql database and order them by votes:

votes_up + votes_down = votes

table:

posts{id, post_text, votes_up, votes_down, date}
ORDER BY votes

Answer 1

SELECT id, post_text, votes_up, votes_down, date, sum(votes_up + votes_down) as 'Votes'
FROM posts
ORDER BY sum(votes_up + votes_down)