libsql icon indicating copy to clipboard operation
libsql copied to clipboard

full text search not working as expected

Open NaviTheCoderboi opened this issue 8 months ago • 1 comments

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'
);

NaviTheCoderboi avatar Mar 28 '25 11:03 NaviTheCoderboi