Lines Matching refs:content
29 CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize porter);
30 INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
31 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
41 INSERT INTO t1(rowid, content)
53 INSERT INTO t1(rowid, content)
67 CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize porter);
68 INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
69 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
75 CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize= porter);
76 INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
77 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
83 CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize= simple);
84 INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
85 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
91 CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize= porter);
92 INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
93 SELECT rowid FROM t1 WHERE content MATCH 'run jump';
99 CREATE VIRTUAL TABLE t1 USING fts3(content, tokenize = porter);
100 INSERT INTO t1(rowid, content) VALUES(1, 'running and jumping');
101 SELECT rowid FROM t1 WHERE content MATCH 'run jump';