View Full Version : MySQL: Fulltext v/s LIKE %keyword%

07-06-2011, 07:53 AM

I was trying to learn what a Fulltext (http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html) search is and was wondering:

1) How is it different from the LIKE '%keyword%' operator?
2) Why should I use a Fulltext search and not the LIKE operator or when to use what?

Can someone please explain this to me?

Many thanks in advance.

07-06-2011, 08:48 AM
Have a look at http://devzone.zend.com/article/1304

07-07-2011, 12:50 AM
Just stumbled upon this, I had no idea what the fulltext search was until now, and now also the boolean... Damn amazing!

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum