Lines Matching refs:content

28   CREATE VIRTUAL TABLE t1 USING fts2(content);
29   INSERT INTO t1 (rowid, content) VALUES(1, 'one');
30   INSERT INTO t1 (rowid, content) VALUES(2, 'two');
31   INSERT INTO t1 (rowid, content) VALUES(3, 'one two');
32   INSERT INTO t1 (rowid, content) VALUES(4, 'three');
34   INSERT INTO t1 (rowid, content) VALUES(5, 'one three');
35   INSERT INTO t1 (rowid, content) VALUES(6, 'two three');
36   INSERT INTO t1 (rowid, content) VALUES(7, 'one two three');
38   INSERT INTO t1 (rowid, content) VALUES(8, 'four');
39   INSERT INTO t1 (rowid, content) VALUES(9, 'one four');
40   INSERT INTO t1 (rowid, content) VALUES(10, 'two four');
42   INSERT INTO t1 (rowid, content) VALUES(11, 'one two four');
43   INSERT INTO t1 (rowid, content) VALUES(12, 'three four');
44   INSERT INTO t1 (rowid, content) VALUES(13, 'one three four');
46   INSERT INTO t1 (rowid, content) VALUES(14, 'two three four');
47   INSERT INTO t1 (rowid, content) VALUES(15, 'one two three four');
48   INSERT INTO t1 (rowid, content) VALUES(16, 'five');
50   INSERT INTO t1 (rowid, content) VALUES(17, 'one five');
51   INSERT INTO t1 (rowid, content) VALUES(18, 'two five');
52   INSERT INTO t1 (rowid, content) VALUES(19, 'one two five');
54   INSERT INTO t1 (rowid, content) VALUES(20, 'three five');
55   INSERT INTO t1 (rowid, content) VALUES(21, 'one three five');
56   INSERT INTO t1 (rowid, content) VALUES(22, 'two three five');
66   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
70   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two'}
74   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three'}
78   execsql {SELECT rowid FROM t1 WHERE content MATCH 'four'}
82   execsql {SELECT rowid FROM t1 WHERE content MATCH 'five'}