Compare this search to the same search done using LIKE
This example shows how to use MySQL to do a more advanced search of a database table using the MATCH() AGAINST() clause. MySQL allows you to create a FULLTEXT index on any text field (including varchar and text fields) that optimizes those fields for search.
If you look at the abloomberg_blogposts table in phpMyAdmin, you will see that there is a FULLTEXT index on the title and message fields. You must create such an index in order to use this technique.
More information on using the MATCH() AGAINST() clauses can be found at http://www.onlamp.com/pub/a/onlamp/2003/06/26/fulltext.html and http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html.