SQL Query using Random

Question

Hi could anyone help me with something?

I need a mysql query that can return 4 values from a column in some table, also select all fiels from each row.

something like:

SELECT * FROM dadoslivros WHERE RAND() =1 limit 100;

But i only want the random form row ID.

Thanks.

How about ordering your results randomly? SELECT * FROM dadoslivros ORDER BY RAND() LIMIT 4 — Cyclonecode
– Cyclonecode, Commented Feb 14, 2013 at 22:43

Taryn · Accepted Answer · 2013-02-14 22:43:50Z

1

It seems like you just want to use ORDER BY RAND():

select *
from dadoslivros
order by rand()
limit 100

answered Feb 14, 2013 at 22:43

Taryn

249k57 gold badges374 silver badges409 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1