MySQL: Fulltext v/s LIKE %keyword%

Databases
1

Hi

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.

2

The link in your post answers both your questions.

3

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

Thanks

4

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.

5

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