how di I retrieve random values in a database?

[Jack_McSlay]

well the question is simple...

what kind of SELECT I should use to retrieve like, 4 random entries?

[mchip]

put all the applicable row id's in an array, then use rand() to select random numbers between 0 and sizeof($array)-1

[Roger_Ramjet]

Or use the mysql rand() function -

$sql = "SELECT * FROM tbl ORDER BY RAND() LIMIT 4";

[Jack_McSlay]

thanks, I was looking for the SQL version, since it's faster and easier to work with (the array one worked already but I wanted something faster)