Lines Matching refs:one

30 # converted to "one three" in english.
33   set english {one two three four five}
54 # one, two, three, four, and five, in various combinations.  The
63   execsql {SELECT rowid FROM t1 WHERE english MATCH 'one'}
66   execsql {SELECT rowid FROM t1 WHERE spanish MATCH 'one'}
69   execsql {SELECT rowid FROM t1 WHERE german MATCH 'one'}
72   execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'one'}
75   execsql {SELECT rowid FROM t1 WHERE t1 MATCH 'one dos drei'}
79 } {one un eine}
81   execsql {SELECT rowid FROM t1 WHERE t1 MATCH '"one un"'}
87     INSERT INTO t2([from],[to]) VALUES ('one two three', 'four five six');
90 } {{one two three} {four five six}}
93 # Compute an SQL string that contains the words one, two, three,... to
99     if {$k&$i} {lappend x [lindex {one two three four five} $j]}
119   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'norm:one'}
122   execsql {SELECT rowid FROM t4 WHERE norm MATCH 'one'}
125   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'one'}
128   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'plusone:one'}
131   execsql {SELECT rowid FROM t4 WHERE plusone MATCH 'one'}
134   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'norm:one plusone:two'}
137   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'norm:one two'}
140   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'plusone:two norm:one'}
143   execsql {SELECT rowid FROM t4 WHERE t4 MATCH 'two norm:one'}