gullinbursti · April 30, 2023 07:50
diff --git a/fast-random-row.sql b/fast-random-row.sql
 SELECT * FROM docs WHERE id <
  (SELECT RAND() * m.maximum AS random_id FROM
    (SELECT MAX(id) AS maximum FROM docs) AS m)
  AND your_conditions
  LIMIT 1
	SELECT * FROM docs WHERE id <
	(SELECT RAND() * m.maximum AS random_id FROM
	(SELECT MAX(id) AS maximum FROM docs) AS m)
	AND your_conditions
	LIMIT 1