Do you have a question? Post it now! No Registration Necessary. Now with pictures!
March 3, 2006, 11:17 pm
rate this thread
MATCH(major, minor) AGAINST ('"mechanical engineering"')
WHERE MATCH(major, minor) AGAINST ('"mechanical engineering"' IN
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?
- » GROUP_CONCAT() produces fatal error in MySQL 4.1.12 - time-sensitive issue
- — Next thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum