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....

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/mysql?unsub=1
>

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