Many Web applications offer full-text search capabilities, wherein the user can locate matching records by using a word or word fragment as the query term. Behind the scenes, these applications are often performing this search by using a LIKE clause in a SELECT query. While this certainly works, it is an extremely inefficient way of performing a full-text search, especially with large volumes of data.
MySQL offers a solution to this problem, in the form of built-in full-text search. Here, the developer need simply mark certain fields as needing full-text search, and then use special MySQL functions to run searches on those fields. This is not only more performance-efficient (because MySQL indexes these fields differently to optimize the search) but also results in higher-quality searches, because MySQL intelligently ranks the results using a natural-language algorithm to remove irrelevant items.
This document will show you how to perform full-text searches in MySQL
Tuesday, March 28, 2006
Subscribe to:
Post Comments (Atom)
Popular Posts
- AS400 Job Scheduler
- Using QCLRDTAQ to clear data queues in CL and RPG
- iReport - OpenSource Java Reporting Tool
- Java Examples - JExamples.com
- Lego Electronic Lab Kit Main
- Creating an as400 Query
- MobileTracker - Cingular announces EDGE Wireless WAN service
- What is QZHQSSRV job?
- Encrypt Data on as400 (QC3ENCDT, Qc3EncryptData)
- A series of tutorials to help you learn Linux fundamentals and prepare for system administrator certification
No comments:
Post a Comment