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
- Creating an as400 Query
- Yahoo! Mail: Revenge of the Oddpost
- AS400 API - QCMDEXC - Execute Command
- as400 Iseries Tips
- Other as400 tips sites
- AS400 PRTF - Report Layout Utility
- AS400 APIs
- What is QZHQSSRV job?
- How do you re-enable the user id for STRSST when it has been disabled?
- Python for as400 programmers