vendredi 26 décembre 2014

select randomnly rows without changing the order in sql query

I searched every where to find sql query to select rows randomly without changing the order almost everyone uses something like this SELECT * FROM table WHERE type = 1 ORDER BY RAND() LIMIT 25 but above query changes the order. I need a query which selects randomly among the rows but dosnt changes the order, cause every record has a date also





Aucun commentaire:

Enregistrer un commentaire