Random MySQL result

[Spike121]

Hey, I'll jump right into it. I need a MySQL code that selects a random result from a table.

 

select link
from table1

 

Would that select a random one, or the latest entry? If it wouldn't select a random result, what would? Also, what would select the latest one too? I need both if possible. Thanks in advance!

[hastishah]

hi

use this query

 

SELECT *

FROM tablename

ORDER BY Rand( )

LIMIT 2 ;