1 2 3 4 5 6 7 8 9 10 11 12
BEGIN; CREATE VIRTUAL TABLE ft USING fts3(a, b, c); INSERT INTO ft VALUES('one', 'one', 'one'); COMMIT; SELECT * FROM ft WHERE ft MATCH 'b:one' SELECT quote(root) FROM ft_segdir;