samedi 26 mai 2018

Return random rows only once in mysql

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