I'm trying to pick random articles from my database, where high rating articles have a higher chance of getting picked
SELECT * FROM articles WHERE RAND()>0.1 ORDER BY rating DESC LIMIT 3
My question is: Will it random the whole table, or just until it finds 3 articles that random a number higher then 0.1
Aucun commentaire:
Enregistrer un commentaire