List:General Discussion« Previous MessageNext Message »
From:Graham Anderson Date:May 11 2005 4:49am
Subject:Re: mysql random function strangeness
View as plain text  
got it to work....

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:
> To unsubscribe:

mysql random function strangenessGraham Anderson11 May
  • Re: mysql random function strangenessGraham Anderson11 May