Re: select 2 random rows

Rory,

> I'd like to select 2 random rows from a table.
> At the moment I'm returning a couple of hundred rows into a perl hash
> and randomising it there, but it would be great if I could do it in the
> database call.
>
> Each row has an id number created using the SERIAL type.

This is actually quite easy:

SELECT *, RANDOM() as random_sort FROM the_table
ORDER BY random_sort LIMIT 2;


--
-Josh Berkus