PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/en/json-search-functions.html
The functions in this section perform search or comparison 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 function serves as counterpart to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-row-searches.html
The algorithm used to carry out this process uses one of the table's indexes to carry out the search as the first choice, and a hash table if there are no suitable indexes. When a replica using row-based replication format applies an UPDATE or ...
https://dev.mysql.com/doc/refman/8.0/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 14.9, “Full-Text Search Functions” applies to the ngram parser plugin. The ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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 ...If ...authentication_kerberos_service_key_tab Command-Line Format --authentication-kerberos-service-key-tab=file_name Introduced 8.0.26 System Variable authentication_kerberos_service_key_tab Scope Global Dynamic No SET_VAR Hint Applies No Type File name Default Value datadir/mysql.keytab The name of the server-side key-table (“keytab”) file containing Kerberos service keys to authenticate MySQL service tickets received from ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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 ...