Never been to DZone Snippets 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

About this user

kellan http://laughingmeme.org

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

Simple query to select N random rows

A very simple, if not particularly portable or fast, quest for selecting a set of random rows from MySQL.
SELECT * from my_table ORDER BY RAND() LIMIT 25

I use this a lot when testing.
to sql random mysql by kellan on Apr 08, 2005
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS