HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Knowledge Base Full Text Query


#1

I’ve been playing around with the full text search of the knowledge base and I have been noticing some odd behavior. If I type in a search like “to angel directly.” I don’t get any results. However, if I run a sql query like the one below I get my article that contains that text back. Any idea what’s going on here?

SELECT *
FROM [helpspot_db].[dbo].[HS_KB_Pages] where tPage like ‘%to angel directly%’


#2

Hi Matt,

The full text search doesn’t use LIKE, it uses the databases native full text indexing system. On most of them you can wrap your query in quotes though to do that kind of match. You may want to drop the “to” and see if that helps because most of them don’t index short words like “to”.