Lines Matching refs:WHERE
3047 ** SELECT x+1, decimal_mul(v,'2') FROM c WHERE x+1<=971
3052 ** SELECT x-1, decimal_mul(v,'0.5') FROM c WHERE x-1>=-1075
3061 ** FROM pow2, c WHERE pow2.x=ieee754_exponent(c.n);
3072 ** FROM pow2, c WHERE pow2.x=ieee754_exponent(c.bin);
3331 ** SELECT * FROM generate_series WHERE start=0 AND stop=100 AND step=5;
3334 ** SELECT * FROM generate_series WHERE start=0 AND stop=100;
3337 ** SELECT * FROM generate_series WHERE start=20 LIMIT 10;
5917 " WHERE sm.type='table'",
9986 "SELECT * FROM main.%Q WHERE sample()", pVtab->pTab->zName
10358 zFmt = "SELECT count(*) FROM sqlite_schema WHERE name=%Q"
10662 "WHERE tbl_name = %Q AND type IN ('table', 'trigger') "
10763 "WHERE type IN ('table','view') AND name NOT LIKE 'sqlite_%%' "
10766 "WHERE type = 'trigger'"
10767 " AND tbl_name IN(SELECT name FROM sqlite_schema WHERE type = 'view') "
10944 "WHERE s.type = 'table'";
11096 "WHERE s.type = 'table'";
11098 "SELECT name, coll FROM pragma_index_xinfo(?) WHERE key";
11190 ** collect information regarding the WHERE, ORDER BY and other clauses
11210 "SELECT sql FROM sqlite_schema WHERE name NOT LIKE 'sqlite_%%'"
12215 "SELECT data FROM sqlite_dbpage(?) WHERE pgno=?", -1,
13308 p, p->dbIn, "SELECT data FROM sqlite_dbpage(%Q) WHERE pgno=?", p->zDb
13465 " SELECT child FROM sqlite_dbptr('getpage()'), pages WHERE pgno=p"
13473 "FROM sqlite_dbdata('getpage()') WHERE pgno IN ("
13769 " WHERE tbl OR isIndex"
13775 "WHERE type='table' ORDER BY rowid DESC LIMIT 1"
13836 " WHERE type!='table' AND type!='index'"
13839 " WHERE type!='table' AND (type!='index' OR sql NOT LIKE '%unique%')"
13991 "SELECT 1 FROM sqlite_schema WHERE name=?"
14101 " SELECT parent FROM recovery.map AS m, p WHERE m.pgno=p.pgno"
14103 "SELECT p.pgno FROM p, recovery.map m WHERE m.pgno=p.pgno "
14243 " SELECT 1 UNION ALL SELECT ii+1 FROM seq WHERE ii<%lld"
14249 "FROM sqlite_dbdata('getpage()') d WHERE d.pgno=? "
14286 " WHERE type='table' AND (sql NOT LIKE 'create virtual%')"
14294 " WHERE pgno=page"
14297 "FROM sqlite_dbdata('getpage()') d, pages p WHERE p.page=d.pgno "
14469 " SELECT read_i32(getpage(1), 8) AS x WHERE x>0"
14471 " SELECT read_i32(getpage(trunk.pgno), 0) AS x FROM trunk WHERE x>0"
14479 " SELECT data, n-1, read_i32(data, 2+n) FROM freelist WHERE n>=0"
14484 " SELECT rootpage FROM recovery.schema WHERE rootpage>0"
14490 " WHERE pgno=page"
14494 "SELECT freepgno FROM freelist WHERE NOT ?"
14541 " SELECT 1 UNION ALL SELECT ii+1 FROM seq WHERE ii<%lld"
14548 "SELECT max(field)+1 FROM sqlite_dbdata('getpage') WHERE pgno = ?"
16992 " WHERE type='table'\n"
17607 " WHERE key=?1", -1, &pQ, 0);
18507 " WHERE origin='pk'", zTab);
20168 " WHERE %s", zWhere);
20197 " WHERE %s ORDER BY rowid DESC", zWhere);
20346 "SELECT count(*) FROM %s WHERE type='table'" },
20348 "SELECT count(*) FROM %s WHERE type='index'" },
20350 "SELECT count(*) FROM %s WHERE type='trigger'" },
20352 "SELECT count(*) FROM %s WHERE type='view'" },
20365 "SELECT data FROM sqlite_dbpage(?1) WHERE pgno=1",
20676 ** "EXPLAIN QUERY PLAN SELECT 1 FROM child_table WHERE child_key=?"
20707 " 'EXPLAIN QUERY PLAN SELECT 1 FROM ' || quote(s.name) || ' WHERE '"
21217 ? "SELECT name FROM %s WHERE glob($name,name)"
21218 : "SELECT name FROM %s WHERE name=$name";
21244 ** Format a WHERE clause that can be used against the "sqlar" table to
21246 ** in (*pAr). Leave this WHERE clause in (*pzWhere) before returning.
21254 char **pzWhere /* OUT: New WHERE clause */
21285 const char *zSql = "SELECT %s FROM %s WHERE %s";
21332 ** And formulate a WHERE clause to match them. */
21337 zSql = sqlite3_mprintf("DELETE FROM %s WHERE %s;",
21371 "FROM %s WHERE (%s) AND (data IS NULL OR $dirOnly = 0)"
21386 ** the archive before proceeding. And formulate a WHERE clause to
21499 " WHERE lsmode(mode) NOT LIKE '?%%'%s;"
21508 " WHERE lsmode(mode) NOT LIKE '?%%'%s;"
21550 " WHERE mem.name=disk.name"
21821 WHERE t.name COLLATE NOCASE IN (\
21822 SELECT o.name FROM ColNames o WHERE o.cpos<>t.cpos\
21846 WHERE substring(t.name,1,t.nlen-t.chop)=substring(d.name,1,d.nlen-d.chop)\
21871 " WHERE EXISTS("
21874 " WHERE"
21914 "FROM ColNames WHERE suff<>'' OR chop!=0"
22418 " SELECT 1 FROM sqlite_schema WHERE "
22452 "WHERE (%s) AND type=='table'"
22462 "WHERE (%s) AND sql NOT NULL"
22736 "WHERE type!='meta' AND sql NOTNULL AND name NOT LIKE 'sqlite_%' "
22744 " WHERE name GLOB 'sqlite_stat[134]'",
23107 " WHERE name='%q' AND type='index'"
23110 " WHERE name='%q' AND type='table'"
23758 "DELETE FROM temp.sqlite_parameters WHERE key=%Q", azArg[2]);
24040 appendText(&sSelect, ") WHERE ", 0);
24487 " WHERE type='table' AND coalesce(rootpage,0)>1"
24492 " WHERE type='table' AND coalesce(rootpage,0)>1"
24689 appendText(&s," WHERE type IN ('table','view')"
24693 appendText(&s," WHERE type='index'"