PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an ...
https://dev.mysql.com/doc/refman/5.7/en/full-text-adding-collation.html
This section describes how to add a user-defined collation for full-text searches using the built-in full-text parser. To add a collation for full-text indexing, use the following procedure. <collation name="latin1_fulltext_ci" id="1025"/> ...The ...
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. Some ...Modifying the default behavior in most cases can actually decrease ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier. | +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes referred to as implied Boolean ...The words might not be in the index because of a combination of factors: if they do not exist in the text, are stopwords, or are shorter than the minimum length of indexed ...
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 ...MATCH() takes a comma-separated list that names the columns to be ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
A collection is a set of one or more columns included in a FULLTEXT index. To perform a case-sensitive full-text search, use a binary collation for the indexed columns. For example, a column that uses the latin1 character set of can be assigned a ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-mecab.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation ...For example, MeCab tokenizes “データベース管理” (“Database Management”) into “データベース” (“Database”) and “管理” ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation when working with ideographic languages that do not use word delimiters. To address this limitation, ...An ngram is a contiguous sequence of n characters from a given sequence of ...As with ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
blind query expansion A special mode of full-text search enabled by the WITH QUERY EXPANSION clause. document id In the InnoDB full-text search feature, a special column in the table containing the FULLTEXT index, to uniquely identify the document ...atomic In the SQL context, transactions are units of work that either succeed entirely (when committed) or have no effect at all (when rolled ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN BOOLEAN MODE searches on a ucs2 column that has no such index. Therefore, the built-in full-text parser ...The exception is that for Unicode, the utf8 character set can be used, but not the ucs2 character ...