Searching for words or phrases
During a word or phrase search, the FTS engine finds requests that contain the specified word or phrase in the field. To perform a word or phrase search, use double-quotation marks around the words to search for. The syntax for the search qualification is
For example, to search for the phrase "firewall blocked", type:
With this example, a full text search finds requests with the phrase "firewall blocked" with the search for blocked expanded to the word stem block with any of its variants.
The following table outlines the expected search results using a word or phrase search.
Results of searches that use a word or phrase search
Qualification | Example data | Matches |
<field> LIKE "firewall blocked"|
firewall blocks access
|
+
firewall will block access |
firewall blocking my access | + |
firewall blocked her access | + |
firewall did not block access |
have the firewall block access | + |
firewall is not working |
try blocking his access |
<field> LIKE "%firewall block%"|
firewall blocks access
|
+
firewall will block access |
firewall blocking my access | + |
firewall blocked her access | + |
firewall did not block access |
have the firewall block access | + |
firewall is not working |
try blocking his access |
<field> LIKE "%firewall blocks%"|
firewall blocks access
|
+
firewall will block access |
firewall blocking my access |
firewall blocked her access |
firewall did not block access |
have the firewall block access |
firewall is not working |
try blocking his access |
<field> LIKE "blocks"|
firewall blocks access
|
+
firewall will block access | + |
firewall blocking my access | + |
firewall blocked her access | + |
firewall did not block access | + |
have the firewall block access | + |
firewall is not working |
try blocking his access | + |
<field> LIKE "%blocks%"|
firewall blocks access
|
+
firewall will block access |
firewall blocking my access |
firewall blocked her access |
firewall did not block access |
have the firewall block access |
firewall is not working |
try blocking his access |
Searching with a wildcard character
Users can use the percent sign (%) wildcard for any type of search to broaden the set of matching requests. For example, searching with the term %fire returns requests with fire and backfire. Searching with fire% returns requests with fire and firewall. Searching with %fire% returns all combinations.
For more information about searching across multiple forms and examples, see Performing-searches-on-multiple-forms.
Searching for variations of word stems
The FTS engine uses stemming to search for common variations of word stems. For example, a word search for the term block returns requests containing these terms:
- block
- blocks
- blocked
- blocking
Searching for blocking returns the same set of requests.
Stemming is not used in the following searches:
- Wildcard searches — For example, if the search term is %blocking%, only requests containing blocking" are returned.
- Case-sensitive searches — For example, a case-sensitive search for block returns only requests containing block.
Related topic