Re: About sorting rows randomly

On Friday 28 March 2003 09:32, Marc Soler wrote:
> Hi all
>
> It's possible to return rows randomly sorted?
>
> Something like this:
>
> Select * from table order by random

SELECT foo, bar, random() AS rand FROM my_table ORDER BY rand

Ian Barwick
barwick@gmx.net