RAND

PostgreSQL equivalent:

Returns a random floating-point number from 0 to 1.

MySQL 8.4

RAND([seed])

Return value

A floating-point number (DOUBLE) from 0 inclusive to 1 exclusive

MySQL 8.4

SELECT RAND();

RAND()
0.8553006871187134

MySQL 8.4

SELECT RAND(1);

RAND(1)
0.40540353712197724

MySQL 8.4

SELECT FLOOR(1 + RAND() * 6);

FLOOR(1 + RAND() * 6)
5

MySQL 8.4

SELECT member_name
FROM FamilyMembers
ORDER BY RAND()
LIMIT 1;

member_name
Ernest Forrest

A random integer from a to b inclusive is given by FLOOR(a + RAND() * (b - a + 1)). ORDER BY RAND() together with LIMIT picks random table rows.