The query extension is used to extend the range of the returned full text search results. Consider the following situations. You want to find all the comments mentioned in anvils. Only one comment contains the word anvils, but you still want to find all other rows that may be related to your search, even if they do not contain anvils. This is also a task of query expansion. When using the query extension, MySQL scans data and indexes twice to complete the search: 1. first, perform a basic full text search to find all rows matching the search condition. 2. secondly, MySQL checks these horses... the query extension is used to extend the range of the returned full text search results. Consider the following situations. You want to find all the comments mentioned in anvils. Only one comment contains the word anvils, but you still want to find all other rows that may be related to your search, even if they do not contain anvils. This is also a task of query expansion. When using the query extension, MySQL scans data and indexes twice to complete the search: 1. first, perform a basic full text search to find all rows matching the search condition. 2. next, MySQL checks these matching rows and selects all useful words (we will briefly explain how MySQL determines what is useful and what is useless ). 3. Next, MySQL searches the entire text again. this time, not only the original conditions, but also all useful words are used. The query extension can be used to find possible results, even if they do not exactly contain the words to be searched. It is only used in MySQL version 4.1.1 or more advanced version query extensions. Therefore, it cannot be used in earlier versions. The following is an example.
1. mysql Query extension technical tutorial
Introduction: Your Location: Home> programming language> ASP. NET technical tutorial [new benefits] favorites excellent articles, free IT books please enter keywords to search [ASP. net mvc Mavericks road] 05-use Ninject litt_j 2014-12-23 2 View 0 Comments public Original report add to favorites [ASP. net mvc Mavericks path] 05-use Ninject in [ASP. net mvc Mavericks road] at the end of the previous article (Dependency Injection (DI) and Ninject) in the series, we mentioned ASP. NET MVC
4. CURL technical knowledge tutorials
Introduction: This article mainly introduces the CURL technical knowledge tutorial series of technical tutorials. For more information about PHP tutorials, see.
5. 20 key points of PHP programming efficiency-PHP technical tutorial
Introduction: 20 key points of PHP programming efficiency-PHP technical tutorials
6. PHP search engine development tutorial
Introduction: The development of search engine technology in PHP allows us to design and develop a strong and efficient search engine and database by ourselves. I am afraid it is impossible to design and develop technologies and funds in a short time. However, since Yahoo is using other people's technologies, can we also use other people's ready-made search engine websites?
7. PHP obtains the script running time
Brief introduction: This article provides web developers with the most complete PHP development-related technical tutorial articles to improve the programming skills of PHP enthusiasts.
8. PHP file operation class (create and write files) to generate logs
Brief introduction: This article provides web developers with the most complete PHP development-related technical tutorial articles to improve the programming skills of PHP enthusiasts.
9. design pattern in php-mediation pattern
Brief introduction: This article provides web developers with the most complete PHP development-related technical tutorial articles to improve the programming skills of PHP enthusiasts.
10. applications referenced in php
Brief introduction: This article provides web developers with the most complete PHP development-related technical tutorial articles to improve the programming skills of PHP enthusiasts.
[Related Q & A recommendations ]:
Python2 crawler builtwith module
The above is a detailed description of 10 articles recommended for technical tutorials. For more information, see other related articles in the first PHP community!