mysql> select * from events order by rand() limit 1; +----+------------+---------------------+-------+ | id | edate | ldate | event | +----+------------+---------------------+-------+ | 28 | 1164585600 | November 27th, 2006 | fgb | +----+------------+---------------------+-------+ 1 row in set (0.01 sec)