Mysql 1 Random Row [duplicate]

Question

Possible Duplicate:
How to request a random row in SQL?

Is this the correct way to do this?

$query = 'SELECT * FROM gameids ORDER BY timestamp RAND LIMIT 1';

Answer 1

Incorrect. You cant order by a column (afaik) if you want it to randomize.

$query = 'SELECT * FROM gameids ORDER BY RAND() LIMIT 1';

Answer 2

You don't need to tell it which column to randomise, but you do need () after RAND because it is a function.

SELECT
  * 
FROM
  gameids 
ORDER BY 
  RAND()
LIMIT 1