Results 1 to 1 of 1
Thread: Boolean vs Full-Text
Jul 16, 2006, 15:20 #1
Boolean vs Full-Text
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.