My program stores a bunch of text in an FTS4 table and makes it available for
search. The wrinkle is, there are conceptually different projects for which the
search has to be compartmentalized.
CREATE TABLE projects (project_id INTEGER PRIMARY KEY, project_name TEXT);
CREATE TABLE documents (document_id INTEGER PRIMARY KEY, document_name TEXT ..,
project_id INTEGER);
CREATE VIRTUAL TABLE fts_docs USING fts4 (document_id, content);
Now, when I search for terms, I would like to target only the content for a
particular project. Would something like the following work --
SELECT Snippet(fts_docs), f.document_id
FROM fts_docs f JOIN
documents d ON f.document_id = d.document_id JOIN
projects p ON p.project_id = d.project_id
WHERE fts_docs MATCH ? AND p.project_name = 'this old project';
or, is there some other way to restrict the MATCH search to only certain rows
in the fts table?
Puneet.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
