Lines Matching refs:execsql

66   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
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'}
96   execsql {SELECT rowid FROM t1 WHERE content MATCH '  ONE    Two   three  '}
100   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one"'}
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"'}
121   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three five"'}
124   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three" five'}
127   execsql {SELECT rowid FROM t1 WHERE content MATCH 'five "one three"'}
130   execsql {SELECT rowid FROM t1 WHERE content MATCH 'five "one three" four'}
133   execsql {SELECT rowid FROM t1 WHERE content MATCH 'five four "one three"'}
136   execsql {SELECT rowid FROM t1 WHERE content MATCH '"one three" four five'}
140   execsql {SELECT rowid FROM t1 WHERE content MATCH 'one'}
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'}
174   execsql {INSERT INTO t1(content) VALUES(NULL)}
178   execsql {SELECT content FROM t1 WHERE rowid=$rowid}
181   execsql {SELECT rowid FROM t1 WHERE content MATCH NULL}
187   execsql {INSERT INTO t1(rowid, content) VALUES(0, 'four five')}
190   execsql {SELECT content FROM t1 WHERE rowid = 0}
193   execsql {INSERT INTO t1(rowid, content) VALUES(-1, 'three four')}
196   execsql {SELECT content FROM t1 WHERE rowid = -1}
199   execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'four'}