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
My apologies if this is a known bug, I could not find a list of known
bugs. The detailed description is below, but basically,
works: match() against () AND match() against()
nope: match() against () OR match() against()
works: match() against ()>0 AND match() against()
nope: match() against