phantom007 — 2011-07-06T02:52:59-04:00 — #1
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.
dan_grossman — 2011-07-06T04:00:37-04:00 — #2
The link in your post answers both your questions.
phantom007 — 2011-07-06T04:23:42-04:00 — #3
Can you please quote me the line from that link that describes the difference between LIKE and full text search?
dan_grossman — 2011-07-06T04:33:38-04:00 — #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.
guelphdad — 2011-07-06T09:41:51-04:00 — #5
You also don't need to post your question in every single mysql forum that you can find as well.