More random RAND() in MYSQL

[Graham Anderson <grahama@xxxxxxxx>]

The ORDER BY RAND() function is not incredibly random
Is there some way to make RAND() a bit more spontaneous ?


$sql = "SELECT media.id,
		artist.name as artist,
		artist.spanish as bio,
		artist.purchaseLink,
		artist.picture,
		media.spanish as trackName,
		media.path,
		media.quality,
		mediaType.id as mediaType
		FROM artist, media, playlistItems, mediaType
		WHERE playlistItems.playlist_id = $myID
		AND playlistItems.media_id = media.id
		AND media.artist_id = artist.id
		AND media.mediaType_id = mediaType.id
        ORDER BY RAND() LIMIT 0, 30";


many thanks
g

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php