Select random row from a SQL database. - SQL Snipplr Social Repository

Revision: 11185

at January 27, 2009 15:16 by xtheonex

Initial Code

SELECT * FROM `table` ORDER BY rand() LIMIT 1

Initial URL

Initial Description

This is by no means the most efficient way to do this, in terms of performance.
It is however the easiest way.

Initial Title

Select random row from a SQL database.

Initial Tags

mysql, sql

Initial Language

SQL