Get All rows from virtual table when no query

86 Views Asked by At

I need to know if it's possible to get all rows from fts table when user doesn't type any text.

I need this, because when app starts, I need to show all rows.

How can I achieve this?

1

There are 1 best solutions below

1
On

There is no MATCH expression that would return all records.

Just make a special case for the empty string, and use the plain

SELECT * FROM MyTable