Lines Matching full:where
64 SELECT t1.b+t2.b AS a, t1.a, t2.a FROM t1, t2 WHERE a==10
74 SELECT a FROM t1 WHERE a>1;
81 SELECT a FROM t1 WHERE a>2147483647;
86 SELECT a FROM t1 WHERE a<2147483648;
91 SELECT a FROM t1 WHERE a<=2147483648;
96 SELECT a FROM t1 WHERE a<10000000000;
101 SELECT a FROM t1 WHERE a<1000000000000 ORDER BY 1;
114 SELECT x1.b AS p, x2.b AS q FROM x AS x1, x AS x2 WHERE x1.a=x2.a;
116 SELECT y1.p, y2.p FROM y AS y1, y AS y2 WHERE y1.q=y2.q;
149 db eval "DELETE FROM t1 WHERE rowid=$rowid"
172 db eval "DELETE FROM t1 WHERE rowid=$rowid"
210 WHERE dim1.n<10 AND dim2.n<10 AND dim3.n<10;
221 WHERE dim1.n>=6 AND dim2.n>=6 AND dim3.n>=6;
232 WHERE dim1.n<5 AND dim2.n<5 AND dim3.n<5 AND dim4.n<5;