libsql
libsql copied to clipboard
full text search not working as expected
guys why does this query not work, even though there are records matching it
SELECT
*
FROM
playlists_fts
WHERE
playlists_fts MATCH 'foo'
ORDER BY
rank;
these are records in the virtual table
[ { title: 'foo', description: 'bar' } ]
i am using libsql client, db is sqlite3 this is migration
CREATE VIRTUAL TABLE playlists_fts USING fts5(
title,
description,
content='playlists',
content_rowid='id'
);