sphinx-searchHow to use forward slash in SphinxSearch?
SphinxSearch uses forward slash (/
) as a special character to separate search terms. It is used to search for exact phrases, and to group search terms together.
Example
SELECT * FROM documents WHERE MATCH('"hello world"/2');
This query will search for documents containing the exact phrase "hello world" with a maximum of two words between them.
Code explanation
SELECT * FROM documents
: This part of the code selects all columns from the documents table.WHERE MATCH('"hello world"/2')
: This part of the code searches for documents containing the exact phrase "hello world" with a maximum of two words between them.
Helpful links
More of Sphinx Search
- How to reload the configuration in SphinxSearch?
- How to query a specific index in SphinxSearch?
- How to use SphinxSearch with PHP?
- How to delete an index in SphinxSearch?
- How to offset results in SphinxSearch?
- How to get the version of SphinxSearch?
- How to configure memory usage in SphinxSearch?
- How to use sql_attr_float in SphinxSearch?
- How to delete data from a realtime index in SphinxSearch?
- How to use query_log_format in SphinxSearch?
See more codes...