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.

Continue reading


  1. 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…

    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…

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: