stevesimo Posted July 11, 2007 Share Posted July 11, 2007 Hi, I have a table which stores details of businesses. I want to know if it is possible using MySQL to generate random results sets. For example suppose there are a total of 30 rows returned from a query, can MySQL randomly generate the order that these 30 results are ordered or will it always return them in the same order? Thanks, Steve Link to comment https://forums.phpfreaks.com/topic/59433-return-records-in-random-order/ Share on other sites More sharing options...
Yesideez Posted July 11, 2007 Share Posted July 11, 2007 You can get it to return a random record but it can be a pain. http://www.desilva.biz/mysql/random.html Link to comment https://forums.phpfreaks.com/topic/59433-return-records-in-random-order/#findComment-295305 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.