mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-12 15:33:44 +00:00
12 lines
347 B
Plaintext
12 lines
347 B
Plaintext
|
|
CREATE VIRTUAL TABLE fts USING fts3( tags TEXT);
|
|
INSERT INTO fts (tags) VALUES ('tag1');
|
|
SELECT * FROM fts WHERE tags MATCH 'tag1';
|
|
|
|
|
|
CREATE VIRTUAL TABLE fts USING fts3(tags TEXT);
|
|
INSERT INTO fts (docid, tags) VALUES (1, 'tag1');
|
|
INSERT INTO fts (docid, tags) VALUES (2, NULL);
|
|
INSERT INTO fts (docid, tags) VALUES (3, 'three');
|
|
|