Hello,

I have set up a full index on a table to enable me to create a simple MySQL search engine. However, there are two modes: boolean and full-text mode. Full-text mode seems to be pulling up more relevant results, but boolean doesn't. The only difference I see is that you can use +, >, <, -, and other various operators in boolean mode, but not in full-text mode.

Why does boolean mode pull up less results?

To my knowledge, full-text mode (or "normal mode") just counts the number of words in found in the column(s) you're searching in and scores it. Are there any disadvantages of using full-text mode compared to boolean mode? I'm considering throwing away boolean mode completely, because I highly doubt that visitors will use the operators or commands, they just want the results.

Thanks in advanced.