Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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 ...The file name should be given as an absolute path ...
https://dev.mysql.com/doc/refman/8.4/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.4/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/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search-mecab.html
To address this limitation for Japanese, MySQL provides a MeCab full-text parser plugin. In addition to tokenizing text into meaningful words, MeCab indexes are typically smaller than ngram indexes, and MeCab full-text searches are generally faster.
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in INFORMATION_SCHEMA string columns can be case-sensitive or case-insensitive, depending on the characteristics of the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-environment-variables.html
You can add folders to the module search path by adding them to the appropriate language-specific module search path environment variable. MySQL Shell includes these folders in the module search paths when you start or restart MySQL Shell. If you ...For JavaScript, folders added to the environment variable are placed at the end of the sys.path variable value, and for Python, they are placed at the ...
https://dev.mysql.com/doc/refman/8.4/en/case-sensitivity.html
This means that if you search with col_name LIKE 'a%', you get all column values that start with A or a. To make this search case-sensitive, make sure that one of the operands has a case-sensitive or binary collation. For nonbinary strings (CHAR, ...A comparison between a nonbinary string and binary string is treated as a comparison of binary ...