I am trying to retrieve random rows from mysql using RAND()
function. But in result rows are repeating more than once. Is there any way to return random rows in such a way that a row is returned only once?
My query is: SELECT h.recid recid, h.name name, h.subtitle subtitle, h.pricingfrom pricingfrom FROM holydays h ORDER BY RAND()
I found this solution but I didnt understand how it works as I don't have any limits... Any answer will be appreciated.!
Aucun commentaire:
Enregistrer un commentaire