Re: mysql random function strangeness

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 resul

mysql random function strangeness

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 r