Never been to CodeSnippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world (or not, you can keep them private!)

About this user

Dan Berlyoung

1 total

On This Page:

  1. 1 Select a random record from a MySQL database

Select a random record from a MySQL database

to mysql by danb on Aug 27, 2008
// description of your code here
I needed to select 5 random records from a MySQL database and found this little squib of code from http://peterfreitag.com/item/466.cfm

SELECT column FROM table ORDER BY RAND() LIMIT 5
1 total

On This Page:

  1. 1 Select a random record from a MySQL database