OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Making ORDER BY RAND() more random [resend]

From: Graham Anderson (grahamasiren.cc)
Date: Mon Oct 03 2005 - 10:33:45 CDT

is there a way to make ORDER BY RAND() at bit more spontaneous ?

I am using it in a php statement:
$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";

the result seems to be pretty predictable ....
is there a way to improve RAND() or is there something better ?
Should I be using php to randomize the found set instead ?

many thanks
g

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=grahamasiren.cc

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql