change the seed on the random function. http://dev.mysql.com/doc/mysql/en/mathematical-functions.html
On Mon, 2005-10-03 at 08:33 -0700, Graham Anderson wrote: > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]