Full Text Search

Full Text Search is a database feature that helps perform more efficient and intelligent searches.

Before this, searches relied on comparisons such as %this is an example%. With these comparisons, if the search included multiple words, they had to be in the exact order in which they were searched.

For example, if your database contains the following text:

"This is an example of how to use full text search."

Without Full Text Search:

• %example of% ? Matches
• %text example% ? Does NOT match

With Full Text Search:

• %example of% ? Matches
• %text example% ? Matches

In other words, with Full Text Search, words do not need to be in a specific order. Instead, the search is performed intelligently and provides a relevance score. If the words are in the correct order, the relevance score is higher, but even if they are not, they are still considered a match, just with a lower relevance score.

Share: