1 2 3 4 5 6 7 8 9 10 11 12
CREATE VIRTUAL TABLE ft USING fts3(x); BEGIN; INSERT INTO ft VALUES('a one'), ('b one'), ('c one'); BEGIN; INSERT INTO ft VALUES('a one'), ('b one'), ('c one'); SELECT docid, optimize(ft) FROM ft WHERE ft MATCH 'one'