Randomising rows in MySQL

[dragonhawk]

Just wondering if there is a way you can select an entire table in MySQL and instead of selecting from top to bottom, it randomises it?

For example, if you do a select * from table, you may get

row 1
row 2
row 3
row 4
etc...

is there a way to select * from table and get randomised rows like so:

row4
row1
row3
row2
etc...

[freakysid]

SELECT *
FROM TableName
ORDER BY RAND()

[dragonhawk]

Perfect... thanks