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
