Application of full text retrieval_PHP tutorial

Basic knowledge
1. There is no full-text search in the DeskTop version of SQL Server7.
2. A table can only have one full-text search.
3. The table being retrieved must have a single column unique index.
4. The full-text index is stored in the file system, not in the database.
5. The process of updating a full-text index is more time-consuming than a regular index, and it cannot be updated immediately by the database system like a regular index.
6. The full-text index is included in the Full-Text Catalog. Each database can contain one or more catalogs, but one catalog cannot belong to multiple databases.
7. Full text search can only be created on real tables, not views, system tables, or temporary tables.
8. Full text search will ignore certain noise words, such as a, the, and in English, 'and', 'is' in Chinese, etc.
9. If noise words are included in the query, an error will occur and these noise words should be removed in the application.
Start the full text search service.
Method A: Open the Support Services folder in Enterprise Manager and select Start in the right-click menu of Full-Text Search.
Method B: Select Microsoft Search in the Services drop-down list of SQL Server Service Manager and click the Start/Continue button.
Method C: Use the command line method of net start mssearch.
Use the Full-Text Indexing Wizard.
step1. Select the database to be retrieved, select Full-text Indexing in the Tools menu, enter the Welcome screen, and click next.
step2. Select the table to be retrieved and click next.
step3. Select a unique index and click next.
step4. Select the indexed column, click Add, and the column will be displayed in the right column. Click next.
step5. Select a directory (select an existing directory or create a new directory) and click next.
step6. Select or create a population schedule (optional) and click next.
step7. Click finish.
Use SQL-DMO (take VB as an example)
step1. Select Microsoft SQLDMO Object Library in the project reference.
step2. Create SQLServer object.
Dim objSQL As New SQLDMO.SQLServer
objSQL.Connect "localhost", "sa", ""
step3. Create a new directory and add it to the indexed database directory.
Dim objCatalog As New SQLDMO.FullTextCatalog
'Enable pubs to be a database for full text retrieval
objSQL.Databases("pubs").EnableFullTextCatalogs
'Create a new catalog
objCatalog.Name = "ftcPubsTest"
'Add the new catalog to the catalog collection
objSQL.Databases("pubs").FullTextCatalogs.Add objCatalog