Thread: MySQL order by random
View Single Post
  #1   IP: 112.87.26.85
Old 2014-04-23, 07:09 PM
Quaker City Quaker City is offline
初级会员
  
Join Date: 2007-07-11
Posts: 1
Quaker City 现在声名狼藉
Default MySQL order by random
To select random rows from mysql database table, you can use below query:

Here, I’m trying to select a random row from a table in a MySQL database.

Syntax:

SELECT * FROM table_name ORDER BY RAND()
Reply With Quote