got it to work....
thanks On May 10, 2005, at 7:22 PM, Graham Anderson wrote:
I have an ORDER statement like: ORDER BY playlist.order_id ASC,RAND(playlistItems.playlist_order)
I am trying to get a random result very time the query is run ... Unfortunately, this statement gives the SAME random result each time
how can I get mysql to randomly jumble the playlist items for a reasonably different result each time ?
many thanks to a great list
-- 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]
