I have a table with five fields:
I want to order the items by their rating.
Not very good.
SELECT * FROM items ORDER BY rating DESC LIMIT 10;
SELECT * FROM items ORDER BY rating DESC WHERE numvotes > 5 LIMIT 10;
However, I would like it that the following:
would score higher than
rating: 4,3 (out of 5)
Since it has alot more votes and is thus a better representation.
How would I be able to do something like that?