SQLite - ORDER BY RAND()

Question

In MySQL I can use the RAND() function, is there any alternative in SQLite 3?

Answer 1

SELECT * FROM table ORDER BY RANDOM() LIMIT 1;