8 recommended courses on full text search

This article gives some important instructions about full-text search. 1. When indexing full text data, short words are ignored and excluded from the index. Short words are defined as those words with 3 or fewer characters (this number can be changed if necessary). 2.MySQL comes with a built-in list of stopwords, which are always ignored when indexing full-text data. This list can be overridden if desired (see the MySQL documentation to learn how to accomplish this). 1. Many words appear so frequently that searching for them is useless (returns too many results). Therefore, MySQL stipulates a 50% rule. If a word appears in more than 50% of the rows, it is ignored as a non-word. The 50% rule does not apply to IN BOOLEANMODE. 2. If there are less than 3 rows in the table, the full text search returns no results (because each word either does not appear, or appears in at least 50% of the rows). 3. Ignore single quotes in words. For example, don't is indexed as dont . 4. Languages ​​that do not have word separators (including Japanese and Chinese) do not return full-text search results appropriately. 5. As before

1. Notes on mysql full text search

Introduction: This article gives some important instructions about full-text search. 1. When indexing full-text data, short words are ignored and excluded from the index. Short words are defined as those words with 3 or fewer characters (this number can be changed if necessary). 2.MySQL comes with a built-in list of stopwords, which are always ignored when indexing full-text data. This list can be overridden if desired (see the MySQL documentation to learn how to accomplish this).

2. mysql boolean text search tutorial

##Introduction: MySQL supports another form of full-text search, called boolean mode. In a Boolean manner, details can be provided about: the words to match; 1. the words to exclude (if a row contains this word, the row is not returned, even if it contains other specified words); 2. Arrangement tips (specify that some words are more important than other words, and more important words have a higher level);

3. mysql query expansion technology tutorial

Introduction: Query expansion is used to try to broaden the scope of the full-text search results returned. Consider the following situation. You want to find all comments that mention anvils. Only one comment contains the word anvils , but you also want to find all other lines that may be relevant to your search, even if they don't contain anvils . This is also a task of query expansion. When using query expansion, MySQL performs two scans of the data and index to complete the search:

4. mysql full text search tutorial

Introduction: After indexing, use the two functions Match() and Against() to perform a full-text search, where Match() specifies the Column to search, Against() specifies the search expression to use. Here is an example: Input: select note_text from productnotes where match(note_text) against('rabbit'); Output:

5. MySQL full text search: enable full text Search support

Introduction: Full text search is generally enabled when creating a table. The CREATE TABLE statement accepts the FULLTEXT clause, which gives a comma-separated list of indexed columns. The following CREATE statement demonstrates the use of the FULLTEXT clause: Input:

6. Introduction to full-text search in MySQL

Introduction: Understanding Full-Text Search Not All Engines Support Full-Text Search As mentioned in Chapter 21, MySQL supports several basic database engines. Not all engines support full-text search as described in this book. The two most commonly used engines are MyISAM and InnoDB. The former supports full-text search, while the latter does not. This is why, although most of the sample tables created in this book use InnoDB, one sample table (the productnotes table) uses MyISAM. You should keep this in mind if your application requires full-text search functionality.

7. MySQL data retrieval + query + full text search_MySQL

Introduction: [0] README0 1 ) Part of the text description in this article is transferred from MySQL Must Know, which is intended to review the basic knowledge of MySQL data retrieval query full text search; [1] Using subqueries 1) Query definition: Any SQL statement is a query. But this term generally refers to s

8. Introduction to MYSQL Part Three: Full Text Search_MySQL

Introduction ：MYSQL introductory learning Part 3: Full text search

The above is the detailed content of 8 recommended courses on full text search. For more information, please follow other related articles on the PHP Chinese website!