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
- Yahoo! Mail: Revenge of the Oddpost
- Creating an as400 Query
- AS400 Job Scheduler
- AS400 PRTF - Report Layout Utility
- Other as400 tips sites
- How do you re-enable the user id for STRSST when it has been disabled?
- Automating a process to run every 10 minutes
- Using QCLRDTAQ to clear data queues in CL and RPG
- What is QZHQSSRV job?
- Get your blog read. Top 100 places to submit your blog