Re: randomized order in select?

On Wed, 10 Mar 2004, Enver ALTIN wrote:

> Hi,
>
> I have got a simple table like this:
>
> create table tips (
> id integer primary key unique,
> tiptext text
> );
>
> and, I've got a website where I'm willing to show these tips in a random
> order. Each visitor will get a randomly selected tip. So for now, I have
> to do 2 queries:
>
> select id from tips
>
> collect an ID list, choose one randomly and retrieve it. I wish I could
> do something like:
>
> select tiptext from tips order by random limit 1

You mean like:

select * from table order by random();

That Works as far back as 7.2, maybe before.