Computer Chess Club Archives


Search

Terms

Messages

Subject: Re: All CCC posts from 1997 until yesterday (2005-12-07)

Author: Dadi Jonsson

Date: 08:55:20 12/10/05

Go up one level in this thread


On December 09, 2005 at 19:10:46, Dann Corbit wrote:

>I tried a bunch of permuations like:
>WAC 230
>and some others.

There is a database setting that dictates the minimum length of words indexed
for fulltext search. Its default setting is 4. Since my setup is run on a shared
server along with numerous other websites I cannot go ahead and change it. In
the example above you were searching for words which are too short to be
indexed. I will discuss with my webhost if they are willing to change the
minimum to 3 characters, when your search would return the results you expected.

>Obviously, I tried the wrong things.

As long as you are looking for words that are at least four characters in length
all kinds of possibilities open up. In your case you might be interested in
quoted searches. Here are some search examples that illustrate the effect of
quoted search strings:

1) Searching for a normal word like "whacked" returns many results.

2) Using a quoted search for "whacked." returns messages where the word is
followed by a period. So putting the search string in quotes allows you to
search for words or sentences with punctuation.

3) Using a quoted search for "whacked.230" returns one message/thread. So you
can actually search for such terms. As explained above the current minimum for
fulltext search would prevent you from finding "wac.230", but you won't find
that either in the message text using the old archive.

4) Another interesting example is using a quoted search for "analysis for
WAC.230". If you use a quoted search for this term it will actually return the
only thread where this text occurs. This happens despite the fact that only the
first word in the expression is actually indexed by the fulltext index! It seems
to me that you cannot do a search like this in the old archives.

Here is a short explanation of the search operators that are available when
searching the archive at my site:
word	Word is optional
+word	Word must be part of the result
-word	Word must not be part of the result
word*	Match different word endings
"word word"	Match whole phrase

I hope you will continue to experiment and let me know if you run into further
problems, as I am learning quite a bit myself from the problems that you run
into!



This page took 0 seconds to execute

Last modified: Thu, 15 Apr 21 08:11:13 -0700

Current Computer Chess Club Forums at Talkchess. This site by Sean Mintz.