Pages

Sunday, November 11, 2012

Selecting random row from mysql database

Here is a simple query to select random row from a phpmysql database

Select * from `users` ORDER BY rand() limit 0,1

where users is the name of my table

1 comment:

  1. Good article

    https://wordpress-special-plugin.blogspot.co.id

    ReplyDelete