intersection search Q&A

jkj2001 · Post by **jkj2001** » Tue Jun 07, 2005 12:45 pm

Hi guys,

A quick on here, I think. If we run this intersection search:

select FIELD01 where FIELD01 like '+David Mike James @0'

...we're guaranteed to return hits with David in them, but Mike and James may or may not be in the results?-- that's correct?

If we wanted at least one of Mike or James to accompany David, would we want to use "@1" instead of "@0"?

Post by **John** » Tue Jun 07, 2005 12:50 pm

@0 means one of Mike or James. @1 would require both.

jkj2001 · Post by **jkj2001** » Tue Jun 07, 2005 3:34 pm

Interesting. So just to make sure I follow, the first search with @0 will return hits with at least one of "Mike" or "James"?

Post by **mark** » Tue Jun 07, 2005 3:44 pm

Right.

Post by **John** » Tue Jun 07, 2005 3:44 pm

Correct.

If you don't need any to match then there is no point in specifying the query terms. The number of intersections is one less than the number of set-logic (not + or -) terms that need to appear (if only one matches then there isn't another one to intersect with).