php - MySQL.. search using Fulltext or using Like? What is better?
I'm working on a search feature for my application, I want to search all articles in the database. As of now, I'm using a
LIKE in my queries, but I want to add a "Related Articles" feature, sort of like what SO has in the sidebar (which I see as a problem if I use Like).
What's better to use for MySQL searching, Fulltext or Like... or anything else I might not know about?
Also, I'm using the Kohana Framework, so If anybody knows an easy way to do fulltext matching using the query builder, I'd appreciate that.