MySQL wrote:
I want searches for News to be on the author, headline and content fields.
What is the best way to index and search this?
I would suggest a Fulltext index on headline and content. And then do a
search using MATCH() and AGAINST(). For searching on author's names you
can use LIKE .
Fr
After reading quite a few online articles about using fulltext indexes in
MySQL, I'm still a little confused about the best solution for my simple
search script. I want to allow users to search for news articles. Here's the
table structure:
CREATE TABLE `news` (
`id` int(7) unsigned NOT NULL aut
