? Sph_match_all, matching all query words (default mode)
? Sph_match_any, matching any one of the query words
? Sph_match_phrase, consider the entire query as a phrase that requires a complete match in order
? Sph_match_boolean, consider a query as a Boolean expression (see section 4.2, "Boolean query Syntax"
? sph_match_extended, consider a query as an expression sphinx the internal query language (see section 4.3, "Extended query Syntax")
There is also a special "full scan" mode, which is automatically activated when the following conditions are met:
The query string is empty (that is, the length is 0) 2. DocInfo storage mode is extern
In full scan mode, all indexed documents are considered to be matched. Such matches are still filtered, sorted, or grouped, but do not do any real full-text searches. This pattern can be used to unify full-text and non full-text search code, or to reduce the burden on SQL Servers (sometimes Sphinx scans are faster than similar MySQL queries)
4.2. Boolean Query
Boolean queries allow the following special operators to be used:? Explicit and operator
Hello & World
? or (or) operator
Hello | World
? non (not) operator
Hello-world Hello!world
? grouping (grouping)
(Hello World)
Here is an example that uses all of the above operators:
Example 5 Boolean Query example
(Cat-dog) | (Cat-mouse)
And operator is the default action, so "Hello World" is actually "Hello & World"
or (or) operator has precedence over the operator, so "Lookingfor cat | Dog | Mouse "means" looking for (cat | dog | mouse) instead of (looking for cat) | Dog | Mouse"
A query like "-dog" cannot be executed because it almost includes indexing all documents. This has both technical and performance reasons. Technically speaking, Sphinx does not always keep a list of all document IDs. Performance, it can take a long time to execute a query when the document set is very large (that is, 10-100m documents).
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.