Best way to get random rows by lucid

[DZ8540]

I wanted to find a similar discussions on this topic, but I could not find any of them. If there are, please post links to them. Thanks.

[Barbapapazes]

Hello, you can use the random function from SQL, order by "rand" and then select the first!

https://sql.sh/fonctions/rand

[DZ8540]

Thanks for answer from @Barbapapazes
Link: #3874 (comment)

BUT

In my case, worked

query.orderByRaw('RANDOM()')

RAND(), not worked.

RANDOM()

RAND()

[Barbapapazes]

Yes, in fact, PostgreSQL implements RANDOM but MySQL use RAND

PostgreSQL: https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-random-range/
MySQL: https://mysqlcode.com/mysql-rand/

[guoyunhe]

Since MySQL and Postgres has different implementation, I think it make sense to have a random(seed?: number) method for query builder, to make your code more portable.