Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQLite Query Language: expression
(lang_expr.html)
... The REGEXP operator is a special syntax for the regexp()
user function. No regexp() user function is defined by default
and so use of the REGEXP operator will normally result in an
error message. If an application-defined SQL function ...
|
|
SQLite Query Language: SQLite Keywords
(lang_keywords.html)
... NULL
OF
OFFSET
ON
OR
ORDER
OTHERS
OUTER
OVER
PARTITION
PLAN
PRAGMA
PRECEDING
PRIMARY
QUERY
RAISE
RANGE
RECURSIVE
REFERENCES
REGEXP
REINDEX
RELEASE
RENAME
REPLACE
RESTRICT
RIGHT
ROLLBACK
ROW
ROWS
SAVEPOINT
SELECT
SET
TABLE
TEMP
TEMPORARY
THEN
TIES
TO
TRANSACTION
TRIGGER ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... Drop all of the triggers that _create_triggers created
#
proc _drop_triggers {db} {
set tlist }; hd_resolve_one {$db eval {SELECT name FROM sqlite_temp_master
WHERE type='trigger'}}; hd_puts {
foreach trigger $tlist {
if {!}; hd_resolve_one {regexp {_.*_(i|u|d)t$} $trigger}; hd_puts {} continue
$db ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.14. The xFindFunction Method
... SELECT * FROM geopolytab WHERE geopoly_overlap(_shape, $query_polygon);
Note that infix functions (LIKE, GLOB, REGEXP, and MATCH) reverse
the order of their arguments. So "like(A,B)" is equivalent to "B like A".
For the form "B like A" the B ...
|
Page generated by FTS5 in about 6.63 ms.