Full-text searching with MySQL
MySQL’s full-text search functions provide a simple framework for an easily implemented, approximate site search. Many sites, written in an interpreted language and powered by MySQL, can use MySQL’s full-text search to avoid third party dependencies.
The basics of the MySQL full-text search functions are well-documented in the MySQL online documentation. For those lacking patience, here is a quick rundown.
Advertisement
Nasty bug in 5.0 (especially for latin languages):
If you search for “arbre”, texts like “l’arbre” will not match…
The apostroph is not properly handled…
http://bugs.mysql.com/bug.php?id=14194
This bug has been corrected in 2006!!! But it is still not commited in a stable release… What a shame…
I have been waiting for MySQL 5.1 stable for years… Still waiting…
Fred
October 23, 2008 at 3:07 pm
Hmm, interesting. Thanks Fred :)
Federico
October 23, 2008 at 9:53 pm