Last Updated: February 25, 2016
·
594
· 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

323.9K
47

Splitting Strings with MySQL

315K
0

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

121.3K
9

Have a fresh tip? Share with Coderwall community!

Post
Post a tip
Best #Mysql Authors
corysimmons
322.3K
#mysql
#HTML
#CSS
fstrube
314.4K
#mysql
#PHP
#Linux
timfernihough
128.6K
#mysql
#mamp
#unix
nicolaskempfpro
107.6K
#mysql
#javascript
#HTML
moezzie
76.96K
#mysql
#Shell
#PHP
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#