Small. Fast. Reliable.
Choose any three.
Choose any three.
|
JSON Functions And Operators
(json1.html)
4.23.1. Examples using json_each() and json_tree()
... SELECT name FROM user WHERE phone LIKE '704-%'
UNION
SELECT user.name
FROM user, json_each(user.phone)
WHERE json_valid(user.phone)
AND json_each.value LIKE '704-%';
Consider a different database with "CREATE TABLE big(json JSON)".
To see a complete ...
|
|
The Virtual Database Engine of SQLite
(vdbe.html)
... Compound SELECT Statements
SQLite also allows two or more SELECT statements to be joined as
peers using operators UNION, UNION ALL, INTERSECT, and EXCEPT. These
compound select statements are implemented using transient tables.
The implementation is slightly different for each ...
|
Page generated by FTS5 in about 36.16 ms.