Thread: Select a row at random?
View Single Post
  #2 (permalink)  
Old 04-19-2006, 05:26 AM
ben ben is offline
Administrator
  
Join Date: Mar 2007
Posts: 92
ben has disabled reputation
Default MySQL answer. Re: Select a row at random?
[sql]
SELECT * FROM some_table ORDER BY RAND() LIMIT 1
[/sql]
Reply With Quote