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 Quote Link to comment 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.