Enabling full text search
() is a keyword-based search and involves indexing before searching so that when a user performs a search, only the index is searched instead of the entire text. can identify stem words and can return the results accordingly. For example, when you search for fire, the search results will include words such as firewall, backfire, firefighter, firecracker, and so on.
can weigh words according to their relevancy depending on where they appear—in a title, a keyword, or the text that is being searched. Results that match the title can be weighted as more relevant and can be displayed among the top search results. For to search across certain fields, the fields must be FTS enabled.
The following topics discuss how to enable full-text search:
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*