Lines Matching refs:two

27 # one, two, three, four, and five, in various combinations.  The
33   INSERT INTO t1(content) VALUES('two');
34   INSERT INTO t1(content) VALUES('one two');
37   INSERT INTO t1(content) VALUES('two three');
38   INSERT INTO t1(content) VALUES('one two three');
41   INSERT INTO t1(content) VALUES('two four');
42   INSERT INTO t1(content) VALUES('one two four');
45   INSERT INTO t1(content) VALUES('two three four');
46   INSERT INTO t1(content) VALUES('one two three four');
49   INSERT INTO t1(content) VALUES('two five');
50   INSERT INTO t1(content) VALUES('one two five');
53   INSERT INTO t1(content) VALUES('two three five');
54   INSERT INTO t1(content) VALUES('one two three five');
57   INSERT INTO t1(content) VALUES('two four five');
58   INSERT INTO t1(content) VALUES('one two four five');
61   INSERT INTO t1(content) VALUES('two three four five');
62   INSERT INTO t1(content) VALUES('one two three four five');
69   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two'}
72   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two one'}
75   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two three'}
78   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one three two'}
81   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two three one'}
84   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two one three'}
87   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three one two'}
90   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three two one'}
93   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two THREE'}
103   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two"'}
106   execsql {SELECT rowid FROM t1 WHERE content MATCH '"two one"'}
109   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two three"'}
112   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three two"'}
115   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two three four"'}
118   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three two four"'}
143   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one -two'}
146   execsql {SELECT rowid FROM t1 WHERE content MATCH '-two one'}
150   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one OR two'}
153   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one two" OR three'}
156   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three OR "one two"'}
159   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two OR three'}
162   execsql {SELECT rowid FROM t1 WHERE content MATCH 'three OR two one'}
165   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one two OR three OR four'}
168   execsql {SELECT rowid FROM t1 WHERE content MATCH 'two OR three OR four one'}