Small. Fast. Reliable.
Choose any three.
Choose any three.
|
SQL Language Expressions
(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 Keywords
(lang_keywords.html)
... NULLS
OF
OFFSET
ON
OR
ORDER
OTHERS
OUTER
OVER
PARTITION
PLAN
PRAGMA
PRECEDING
PRIMARY
QUERY
RAISE
RANGE
RECURSIVE
REFERENCES
REGEXP
REINDEX
RELEASE
RENAME
REPLACE
RESTRICT
RETURNING
RIGHT
ROLLBACK
ROW
ROWS
SAVEPOINT
SELECT
SET
TABLE
TEMP
TEMPORARY
THEN
TIES
TO
TRANSACTION ...
|
|
The Virtual Table Mechanism Of SQLite
(vtab.html)
2.3.1. Inputs
... LIKE, GLOB, REGEXP, and MATCH functions
For the LIKE, GLOB, REGEXP, and MATCH operators, the
aConstraint[].iColumn value is the virtual table column that
is the left operand of the operator. However, if these operators
are expressed as function calls ...
|
|
Automatic Undo/Redo With SQLite
(undoredo.html)
... Drop all of the triggers that _create_triggers created
#
proc _drop_triggers {db} {
set tlist [$db eval {SELECT name FROM sqlite_temp_schema
WHERE type='trigger'}]
foreach trigger $tlist {
if {![regexp {_.*_(i|u|d)t$} $trigger]} continue
$db ...
|
|
Command Line Shell For SQLite
(cli.html)
19. Miscellaneous Extension Features
... decimal extension;
the generate_series() table-valued function;
the base64() and base85() functions which encode a
blob to base64 or base85 text or decode the same to a blob; and
support for POSIX extended regular expressions
bound to the REGEXP operator.
|
Page generated by FTS5 in about 6.96 ms.