FREETEXT provides a simple mechanism by which to perform SQL Server 2005 full-text searches, matching by meaning as opposed to exact text match. Here is a simple example:
SELECT *
FROM my_table
WHERE FREETEXT(column1, 'rabbit food');
FREETEXT(column1, ‘rabbit food’) means perform a FREETEXT lookup on column column1 looking for anything that could mean rabbit food (but not necessarily those two exact words, and not necessarily as a phrase).
You can also search across all columns indexed for full-text search by using FREETEXT(*, ‘search text’).
If double quotes surround a search term then that exact phrase is matched, not the meaning.
Leave a Reply