Lines Matching full:where

38     WHERE type='index' AND tbl_name='t1';
50       WHERE type='index' AND tbl_name='t1';
117     UPDATE t1 SET a=4 WHERE b='one';
127     SELECT * FROM t1 WHERE a==4;
168     SELECT * FROM t1 WHERE b=='y'
173     SELECT * FROM t1 WHERE b=='y' AND rowid<0
178     SELECT * FROM t1 WHERE b=='y' AND rowid<0 AND rowid>=-20
183     SELECT * FROM t1 WHERE b>='y'
188     SELECT * FROM t1 WHERE b>='y' AND rowid<10
194     UPDATE t1 SET a=8 WHERE b=='y';
195     SELECT * FROM t1 WHERE b=='y';
205     SELECT rowid, * FROM t1 WHERE b<'second'
210     SELECT rowid, * FROM t1 WHERE 'second'>b
215     SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b
220     SELECT rowid, * FROM t1 WHERE 8>rowid AND 'second'>b AND 0<rowid
225     SELECT rowid, * FROM t1 WHERE b>'a'
230     DELETE FROM t1 WHERE rowid=4;
231     SELECT * FROM t1 WHERE b>'a';
236     UPDATE t1 SET a=-4 WHERE rowid=8;
237     SELECT * FROM t1 WHERE b>'a';
263     SELECT * FROM t1 WHERE a=5;
268     SELECT * FROM t1 WHERE a>4 AND a<6;
273     SELECT * FROM t1 WHERE b>='hello' AND b<'hello2';
283     SELECT * FROM t1 WHERE c=='world';
289     SELECT * FROM t1 WHERE c=='world';
294     SELECT * FROM t1 WHERE c=='world' AND a>7;
299     SELECT * FROM t1 WHERE 7<a;
307     SELECT * FROM t1 WHERE 11=rowid
312     SELECT * FROM t1 WHERE 11=rowid AND b=='hello'
317     SELECT * FROM t1 WHERE 11=rowid AND b=='hello' AND c IS NOT NULL;
322     SELECT * FROM t1 WHERE rowid==11
327     SELECT * FROM t1 WHERE oid==11 AND b=='hello'
332     SELECT * FROM t1 WHERE a==11 AND b=='hello' AND c IS NOT NULL;
338     SELECT * FROM t1 WHERE 8<rowid;
343     SELECT * FROM t1 WHERE 8<rowid AND 11>=oid;
348     SELECT * FROM t1 WHERE 11<=_rowid_ AND 12>=a;
353     SELECT * FROM t1 WHERE 0>=_rowid_;
358     SELECT * FROM t1 WHERE a<0;
363     SELECT * FROM t1 WHERE a<0 AND a>10;
374     SELECT * FROM t1 WHERE a=0;
394     SELECT * FROM t1 WHERE a>=20;
399     SELECT * FROM t1 WHERE b=='hello'
404     DELETE FROM t1 WHERE b='b-21';
405     SELECT * FROM t1 WHERE b=='b-21';
410     SELECT * FROM t1 WHERE a>=20
419     SELECT * FROM t1 WHERE rowid>=30;
424     SELECT * FROM t1 WHERE rowid>20;
445     UPDATE t1 SET c='www' WHERE c='world';
446     SELECT rowid, a, c FROM t1 WHERE c=='www';
464     SELECT * from t2 WHERE x=2;
479     SELECT b FROM t1 WHERE a=2.0+3.0;
484     SELECT b FROM t1 WHERE a=2.0+3.5;