By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,133 Members | 1,092 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,133 IT Pros & Developers. It's quick & easy.

FULLTEXT search IN BOOLEAN MODE fails - why?

P: n/a
SELECT id, student_first_name, student_last_name, major, minor ,
MATCH(major, minor) AGAINST ('"mechanical engineering"')
AS score
FROM students
WHERE MATCH(major, minor) AGAINST ('"mechanical engineering"' IN
BOOLEAN MODE)
GROUP BY id, student_first_name, student_last_name, major, minor, score
ORDER BY score DESC

This query in MySQL 4.1.12 using MyISAM tables with FULLTEXT index that
maps to student.major, student.minor, produces results that do this:

1) Matches major/minor "Mechanical Engineering"
2) Matches major/minor "Mechanical"
3) Matches major/minor "Mechanic"
4) Matches major/minor "Engineering"
5) Matches major/minor "Engineer"

I was under the impression, according to this MySQL book I have "MySQL
(Third Edition", Paul DuBois, Developer's Library), in Chapter 2, page
197 that if you group your search keyword in double quotes, you will
get only the results within double quotes IN BOOLEAN MODE.

Apparently this is not happening.

Can someone tell me what on earth I did wrong to cause this to happen?

Thanx
Phil

Mar 3 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.