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
>
