I have a table with a large text field which I use verity to index.
This is fine to search on it's own, but the table also contains other columns that I'd like to filter by where this is usually done with a database query. How can I combine them both? Are there best practices?
The table would be:
articles
articleID int
categoryID int
articleText ntext
To narrow the search to a category I would normally use:
SELECT *
FROM articles
WHERE categoryID = 7
But I also want verity to do a keyword search on the articleText column
This is fine to search on it's own, but the table also contains other columns that I'd like to filter by where this is usually done with a database query. How can I combine them both? Are there best practices?
The table would be:
articles
articleID int
categoryID int
articleText ntext
To narrow the search to a category I would normally use:
SELECT *
FROM articles
WHERE categoryID = 7
But I also want verity to do a keyword search on the articleText column