SQLite - ORDER BY RAND()

sql mysql database sqlite random-access
Alix Axel picture Alix Axel · Aug 10, 2009 · Viewed 50.2k times · Source

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

Answer

avnic picture avnic · Aug 10, 2009 
SELECT * FROM table ORDER BY RANDOM() LIMIT 1;

Related questions

SQLite INSERT - ON DUPLICATE KEY UPDATE (UPSERT)

MySQL has something like this: INSERT INTO visits (ip, hits) VALUES ('127.0.0.1', 1) ON DUPLICATE KEY UPDATE hits = hits + 1; As far as I know this feature doesn't exist in SQLite, what I want to know is if there is any …

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More
MySQL Error: : 'Access denied for user 'root'@'localhost'

$ ./mysqladmin -u root -p 'redacted' Enter password: mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)' How can I fix this?

Read More