Last Updated: February 25, 2016
·
621
· sunng

Return random ordered records in MySQL

#mysql
 
SELECT *
FROM xxx
ORDER BY RAND()
LIMIT 5
#mysql

Written by Sun Ning

Say Thanks
Respond

Related protips

Uninstall all those broken versions of MySQL and re-install it with Brew on Mac Mavericks

330.1K
46

Splitting Strings with MySQL

316.6K
0

SOLVED: Can't connect to local mySQL server through socket /tmp/mysql.sock

122.1K
9

Have a fresh tip? Share with Coderwall community!

Post
Post a tip
Best #Mysql Authors
corysimmons
329.9K
#mysql
#HTML
#CSS
fstrube
316.5K
#mysql
#PHP
#Linux
timfernihough
129.9K
#mysql
#mamp
#unix
nicolaskempfpro
108.5K
#mysql
#javascript
#HTML
groodt
84.46K
#mysql
#Python
#Open Source
Related Tags
#mysql
Sponsored by
#native_company#
#native_desc#
#native_cta#
Awesome Job
See All Jobs
Post a job for only $299
Thanks to our sponsor
Sponsored by #native_company# — Learn More
#native_title# #native_desc#
#native_cta#