Thunderstone Support Forums

Hi,

We have the term university in our noise list.

when executing a search like this

select * from jobs where field/field2/filed2 like +(university,faculty)

returns different results than this:

select * from jobs where field/field2/filed2 like +(faculty,university)


The first query looks like all terms are dropped from it while the second one looks like it only drops the "university" part of the query.

Could you explain this?

Thanks

A paren list is treated as a manually entered equiv list. So the first term is the root word and others are "equivalents". If the root word is noise the set is stripped. If not the set is kept and noise terms are stripped from the list of equivalents.