New answers tagged


For InnoDB, FULLTEXT(title,body) -- useful only for MATCH(title, body) AGAINST ... FULLTEXT(title) -- useful only for MATCH(title) AGAINST ... So, if you are doing both types of MATCH, you need both indexes.


You can use DMV sys.dm_fts_index_keywords_by_document to list the words for a given document, eg something like this: SELECT DISTINCT display_term FROM sys.dm_fts_index_keywords_by_document( DB_ID(), OBJECT_ID('dbo.Users') ) X I had a play with this product a few years ago that does hit-highlighting, it was quite nice but I didn't go past the 30-day ...


Like our expert ypercube mentioned, you can use LIKE if you know the phrase to be searched. Otherwise you can also use something called CHARINDEX which I personally find a very useful command in SQL. I'll give you a small example. Suppose you have a keyword and you want to search that keyword in a column or a group of column, you can do it pretty easily. ...

Top 50 recent answers are included