MySQL: Fulltext v/s LIKE %keyword%


I was trying to learn what a Fulltext 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.

The link in your post answers both your questions.

Can you please quote me the line from that link that describes the difference between LIKE and full text search?


No, because pretty much every line on that page describes something wholly different than a LIKE search. Just read it, and the rest of the section on FULLTEXT. It’s nothing like a substring search in a column which is all LIKE does.

You also don’t need to post your question in every single mysql forum that you can find as well.