Making w/99 mean word

Post Reply
tboyer
Posts: 68
Joined: Mon Aug 28, 2006 4:43 pm

Making w/99 mean word

Post by tboyer »

We're thinking about changing the setting to make the w/X operator mean number of WORDS not characters. We think our users would relate to this more easily -- w/2 means within 2 words.

If we do that, is that based on an approximation of word length (i.e. 1 word=8 characters) or is it really based on actual words?

Related question: When a user use the asterisk at the end of a word, does it stop at the end of the word? If I search foo* I expect to get foobar but do I also get foo bar.

I assume there's no way to limit that wild card to fewer characters.

Thanks, Tom
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

Making w/99 mean word

Post by mark »

apicp withinmode word is actual words, not an approximation by number of characters.

SQL set wildsingle=1; will enable word boundaries for wildcards.
Post Reply