Lines Matching refs:two

28 # one, two, three, four, and five, in various combinations.  The
34   INSERT INTO t1(content) VALUES('two');
35   INSERT INTO t1(content) VALUES('one two');
38   INSERT INTO t1(content) VALUES('two three');
39   INSERT INTO t1(content) VALUES('one two three');
42   INSERT INTO t1(content) VALUES('two four');
43   INSERT INTO t1(content) VALUES('one two four');
46   INSERT INTO t1(content) VALUES('two three four');
47   INSERT INTO t1(content) VALUES('one two three four');
50   INSERT INTO t1(content) VALUES('two five');
51   INSERT INTO t1(content) VALUES('one two five');
54   INSERT INTO t1(content) VALUES('two three five');
55   INSERT INTO t1(content) VALUES('one two three five');
58   INSERT INTO t1(content) VALUES('two four five');
59   INSERT INTO t1(content) VALUES('one two four five');
62   INSERT INTO t1(content) VALUES('two three four five');
63   INSERT INTO t1(content) VALUES('one two three four five');
70   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two'}
73   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two one'}
76   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two three'}
79   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one three two'}
82   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two three one'}
85   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two one three'}
88   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three one two'}
91   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three two one'}
94   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two THREE'}
104   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two"'}
107   execsql {SELECT rowid FROM t1 WHERE content MATCH '"two one"'}
110   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two three"'}
113   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three two"'}
116   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two three four"'}
119   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three two four"'}
144   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one -two'}
147   execsql {SELECT rowid FROM t1 WHERE content MATCH '-two one'}
151   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one OR two'}
154   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two" OR three'}
157   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three OR "one two"'}
160   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two OR three'}
163   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three OR two one'}
166   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two OR three OR four'}
169   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two OR three OR four one'}
255   INSERT INTO z1 VALUES('one two three'),('four one five'),('six two five');