Select random row from an sqlite table.

Question

I have an sqlite table with the following schema:

CREATE TABLE foo (bar VARCHAR)

I'm using this table as storage for a list of strings.

How do I select a random row from this table?

Answer 1

Have a look at Selecting a Random Row from an SQLite Table

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

Answer 2

SELECT   bar
FROM     foo
ORDER BY Random()
LIMIT    1