Chapter 13. Full-text searching

Robert C. Cain

Search is everywhere. In addition to the powerful search engines available to us, it seems like every website we visit has a search box for searching within that site. Wouldn’t it be great to incorporate search within your applications? Fortunately, SQL Server provides a powerful text search engine that’s as easy to use as one-two-three!

Foundations of full-text searching

Before we begin the step-by-step process of creating and using full-text indexes, there are a few fundamentals that you’ll need to understand. Full-text search isn’t a fancy way of doing a LIKE search with SQL. Instead, every word is placed into a special type of index called a full-text index. These indexes are organized and ...

Get SQL Server MVP Deep Dives now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.