PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html
MATCH (col1,col2,...) AGAINST (expr [search_modifier]) search_modifier: { IN NATURAL LANGUAGE MODE | IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION | IN BOOLEAN MODE | WITH QUERY EXPANSION } MySQL has support for full-text indexing and searching: A ...Full-text indexes can be used only with InnoDB or MyISAM tables, and can be created only for CHAR, VARCHAR, or TEXT ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
With this modifier, certain characters have special meaning at the beginning or end of words in the search string. | +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...In the following query, the + and - operators ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
This causes no additional overhead, because the MySQL optimizer notices that the two MATCH() calls are identical and invokes the full-text search code only once. MyISAM Limitation For very small tables, word distribution does not adequately reflect ... By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
The functions in this section perform search operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. This includes (but is not limited to) SELECT lists, ...
https://dev.mysql.com/doc/refman/5.7/en/searching-on-two-keys.html
The one tricky case is that of searching on two different keys combined with OR: SELECT field1_index, field2_index FROM test_table WHERE field1_index = '1' OR field2_index = '1' This case is optimized. Each SELECT searches only one key and can be ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
To address this limitation, MySQL provides an ngram full-text parser that supports Chinese, Japanese, and Korean (CJK). The full-text search syntax described in Section 12.9, “Full-Text Search Functions” applies to the ngram parser plugin. The ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication-system-variables.html
This variable can be used to limit the scope of searches by anchoring them at a certain location (the “base”) within the search tree. This variable is used in conjunction with authentication_ldap_sasl_bind_root_pwd as the credentials for ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-query-expansion.html
This is generally useful when a search phrase is too short, which often means that the user is relying on implied knowledge that the full-text search engine lacks. Full-text search supports query expansion (and in particular, its variant “blind ...| +----+-------------------+------------------------------------------+ 2 rows in set (0.00 sec) mysql> SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database' WITH QUERY EXPANSION); +----+-----------------------+------------------------------------------+ | id | title | body | +----+-----------------------+------------------------------------------+ | 5 | MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
This technique is mainly applicable for short search phrases, perhaps only a single word. This data cannot be used for manual recovery; for that type of operation, use the binary log. This feature is currently supported in MyISAM full-text search ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code modifications. Most full-text variables described in this section must be set at server startup time. For ...Modifying the default behavior in most cases can actually decrease ...