mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 08:39:46 +00:00
11 lines
292 B
Plaintext
11 lines
292 B
Plaintext
|
|
CREATE VIRTUAL TABLE x USING fts4(y,z);
|
|
INSERT INTO x VALUES('aaa bbb ccc ddd', 'bbb ddd aaa ccc');
|
|
SELECT * FROM x where y MATCH 'bbb NEAR/6 aaa';
|
|
|
|
|
|
CREATE VIRTUAL TABLE t2 USING fts4(a, b);
|
|
INSERT INTO t2 VALUES('A B C', 'A D E');
|
|
SELECT * FROM t2 where t2 MATCH 'a:A NEAR E'
|
|
|