Re: [SQL] randomized order in select?

) after random: > select tiptext from tips order by random() limit 1 Thanks. The whole table consists of about 100 rows and I don't think it will grow by, even twice. So this fits my needs just well. -- __ | | | | Enver ALTIN (a.k.a. skyblue) | |

[SQL] randomized order in select?

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 in PostgreSQL. -- __ | | | | Enver ALTIN (a.k.