mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 23:48:49 +00:00
15 lines
369 B
Plaintext
15 lines
369 B
Plaintext
|
|
CREATE VIRTUAL TABLE t1 USING fts3(a, b);
|
|
INSERT INTO t1 VALUES('one two', 'one');
|
|
INSERT INTO t1 VALUES('one two', 'three');
|
|
INSERT INTO t1 VALUES('one two', 'two');
|
|
|
|
|
|
SELECT * FROM t1 WHERE t1 MATCH 'one'
|
|
ORDER BY rank(matchinfo(t1), 1.0, 1.0) DESC, rowid
|
|
|
|
|
|
SELECT * FROM t1 WHERE t1 MATCH 'two'
|
|
ORDER BY rank(matchinfo(t1), 1.0, 1.0) DESC, rowid
|
|
|