0

I`m maked SQLite database like

      ID  |  CHAPTER  |  Content
  --------------------
   1  |  1    |  xxxxxxxxx
   1  |  2    |  xxxxxxxxx
   1  |  3    |  xxxxxxxxx
   2  |  1    |  xxxxxxxxx
   2  |  2    |  xxxxxxxxx

how to get random row content from database?

CoderTM
  • 11

1 Answers1

0

Answer from Select random row from an sqlite table

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

SELECT * FROM table ORDER BY RANDOM() LIMIT 1;
Carol Ng
  • 575
  • 2
  • 11