Hi!
On Mar 21, Shane Allen wrote:
> 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)
Yes. It could be simplified to
'+(obgyn pediatrics) +ambulatory'
> "Training" AND "Documentation" OR "Technical Writer":
> MATCH (jobdescription) AGAINST('+("Training") +("Documentation"
> "Technical Writer")' IN BOOLEAN MODE)
Correct. Or
'+Training +(Documentation "Technical Writer")'
> "art" OR "graphic" OR "publishing":
> MATCH (jobdescription) AGAINST('+("art" "graphic" "publishing")' IN
> BOOLEAN MODE)
Yes. Or simply
'art graphic publishing'
> "web design" AND "web development" AND "webmaster":
> MATCH (jobdescription) AGAINST('+("web design") +("web development")
> +("webmaster")' IN BOOLEAN MODE)
Yes. Or
'+"web design" +"web development" +"webmaster"'
If you find that some of the above doesn't work as expected -
report at http://bugs.mysql.com :)
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
