hi, has anyone ever used the FTS feature of sqlite?
i use the fts feature，have problem.
SELECT * FROM fts_article WHERE content MATCH ?;
this is my sql code.
when i search content from the virtual table，it must full match。
how can i search by partial match?
Steps to Reproduce
search content from virtual table, can partial match
Issue Summary
hi, has anyone ever used the FTS feature of sqlite? i use the fts feature，have problem. SELECT * FROM fts_article WHERE content MATCH ?; this is my sql code. when i search content from the virtual table，it must full match。 how can i search by partial match?
Steps to Reproduce
search content from virtual table, can partial match
Version
5.0.2
Node.js Version
18
How did you install the library?
npm