Options for full-text search
Contents
Since the version 2.3, the Solr search engine is available and recommended, while alternatives are Microsoft SQL search engine (since version 2.0) and MySQL search engine (since version 2.1). In versions 2.2 and earlier, the Exalead search engine was available too. In versions 1.6 and earlier, the Exalead search engine was the only available for the full-text search..
Standard options
Option |
Matches the records which in the chosen field contain |
None |
Does not perform search. |
All |
AND search: Only documents that contain all words from your search request are shown. The more words you put in your search request, the more precise the search becomes. It looks for the whole words. |
Some |
OR search: Only documents that contain any of words from your search request are shown. The more words you put in your search request, the more results are returned. It looks for the parts of the words. |
Near |
Proximity Search: The "NEAR" operator finds content where the query terms are all in a short range of words (before or after) It looks for the whole words. |
Exact |
Phrase search: This excludes content where the words occur but are not next to one another or are in the wrong order. |
ButNot (Exalead only) |
Exclude search: Excludes all content containing a specific word or expression from the search results. |
SoundsLike (Exalead only) |
Phonetic search: When you do not know how to spell a word, write it as it sounds and use a phonetic search. Results will include words that sound like what you typed. Not available in the SQL full-text search. |
SpellsLike (Exalead only) |
Approximate spelling search: When you are not sure about the spelling of a word, you can search with spelling approximation. Not available in the SQL full-text search. |
* (wildcard) |
For Solr and Exalead an asterisk is supported on the beginning and and on the end of the word, while in SQL it is supported only at the end of the word. |
Additional search options
Solr search engine
Operator |
Description |
Example |
|---|---|---|
word1 AND word2 |
if the content contains both words |
User AND interface |
word1 OR word2 |
if the content contains any of words |
User OR interface |
word1 AND NOT word2 |
negation |
User NOT interface |
word1 NEAR word2 |
if the word 2 is close to the word1 (before or after it) |
User NEAR inteface |
SQL search engine
Operator |
Description |
Example |
|---|---|---|
word1 AND word2 |
if the content contains both words |
User AND interface |
word1 OR word2 |
if the content contains any of words |
User OR interface |
word1 AND NOT word2 |
negation |
User NOT interface |
word1 NEAR word2 |
if the word 2 is close to the word1 (before or after it) |
User NEAR inteface |
Exalead search engine
Operator |
Description |
Example |
|---|---|---|
word1 AND word2 |
if the content contains both words |
User AND interface |
word1 OR word2 |
if the content contains any of words |
User OR interface |
word1 word2 |
equivalent to AND |
User interface |
NOT word1 |
negation |
Not myword |
word1 NEAR word2 |
if the word 2 is close to the word1 (before or after it) |
User NEAR inteface |
word1 NEAR/x word 2 |
as above, but you can specify "how much". Note: the X includes the word2, so if there are two words between the word1 and word2, you need to enter 3. |
User NEAR/3 interface |
word1 AFTER word2 |
if the word2 is after the word1 |
interface AFTER user |
word1 AFTER/x word2 |
as above, but you can specify "how much". Note: the X includes the word2, so if there are two words between the word1 and word2, you need to enter 3. |
interface AFTER/3 user |
word1 BEFORE word2 |
if the word2 is before the word1 |
User BEFORE interface |
word1 BEFORE/x word2 |
as above, but you can specify "how much". Note: the X includes the word2, so if there are two words between the word1 and word2, you need to enter 3. |
User BEFORE/3 interface |
word1 NEXT word2 |
if the words are adjacent in this order in the document. |
User NEXT interface |
word1 MIN word2 |
as word1 AND word2 but ranking results by distance: the content with the minimum distance is on top. |
User MIN interface |
word1 MAX word2 |
Disjunction match operator performs matching of word1 OR word2 and then keeps the maximum score. |
design MAX conception |
word1 BUTNOT word2 |
New BUTNOT "New York" will match if there is at least an instance of the word "new" not followed by "york" |
New BUTNOT "New York" |
word1 SPLIT word2 |
A document is returned if the word1 is found in at least one of the sections of the document delimited by occurrences of the word2 separator expression. As a consequence, note that if the separator word2 is not present in a document, then the content is returned if word1 is found. Note that the split operator cannot be nested. |
"user interface" SPLIT Chapter matches if "user interface" is found between two "Chapter" |
Technicalities
For the list of operators, see Op codes.