On 2016/04/13 6:44 PM, John Found wrote: > On Wed, 13 Apr 2016 23:38:04 +0700 > Dan Kennedy <danielk1977 at gmail.com> wrote: > >> On 04/13/2016 11:24 PM, John Found wrote: >>> What FTS5 query should I use in order to match all rows in the table? >>> >> Can you use "SELECT * FROM fts_table;"? >> > *I* can. But the users of the program where I use SQLite can't simply run > arbitrary SQL statements.
Ok... but then what good would knowing a "query that will return all rows" be to you if they cannot run arbitrary queries? The query Dan listed is the one that will do it. Either you program it in your application, or you teach the users to do it, what other way would there be to run any query of any kind? Or did you mean you publish an interface of sorts in your application that allows users to run their own queries, but it /has/ to be an "fts5" query in some way, and now sometimes they want to list all rows? It is quite baffling - but I might simply not understand the situation, perhaps some more information on the setup would help us see the light and help us to offer better suggestions than this :) Cheers! Ryan
