FULLTEXT query format question

[Shane Allen]

I've read through the boolean mode fulltext docs, and they address all 
my questions well except how searches containing exact phrases are 
handled when there is more than one. I believe the following will work 
as I expect, but was wondering if anyone can confirm it for me:

Given the following search strings, are the following MATCH AGAINST 
(BOOLEAN) going to operate as the search strings suggest?

Based on a discussion with a coworker, we've determined in the old 
search strings that OR has a higher precedence than AND (the goal of the 
first being either "ambulatory pediatrics" or "ambulatory obgyn", for 
example)

"obgyn" OR "pediatrics" AND "ambulatory":
MATCH (jobdescription) AGAINST('+("obgyn" "pediatrics") +("ambulatory")' 
IN BOOLEAN MODE)

"Training" AND "Documentation" OR "Technical Writer":
MATCH (jobdescription) AGAINST('+("Training") +("Documentation" 
"Technical Writer")' IN BOOLEAN MODE)

"art" OR "graphic" OR "publishing":
MATCH (jobdescription) AGAINST('+("art" "graphic" "publishing")' IN 
BOOLEAN MODE)

"web design" AND "web development" AND "webmaster":
MATCH (jobdescription) AGAINST('+("web design") +("web development") 
+("webmaster")' IN BOOLEAN MODE)



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]