3 replies

Selecting a random record (libSQL SQLite)

I have a table of questions and I would like to select a single random record to create a quiz.

In raw SQL I would use

SELECT * FROM questions ORDER BY RANDOM() LIMIT(1)

SELECT * FROM questions ORDER BY RANDOM() LIMIT(1)

I have no idea how to model this into a drizzle query as there only seem to be asc and desc methods on orderBy - I am using libSQL

Thanks

Selecting a random record (libSQL SQLite) - Drizzle Team