Full Text Search Question

------=_NextPart_000_0005_01C5F009.D9C0CBB0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm new to using full text searching.... I've created an index on a =
smaller table. I'm getting no results when a word exists in most of the =
rows... I know this is the way it was designed, but is there thing that =
can change it?


Melissa
------=_NextPart_000_0005_01C5F009.D9C0CBB0--

Re: Full Text Search Question

Please post more information, like your table structure and the query
designed to get the information, without this its kinda hard to
recognize your problem. Full text search should get you the results no
matter what indices and words are you looking for, as long as you use
the LIKE statement and % on the search string.

On 11/23/05, Melissa Dougherty wrote:
> I'm new to using full text searching.... I've created an index on a small=
er table. I'm getting no results when a word exists in most of the rows...=
I know this is the way it was designed, but is there thing that can change=
it?
>
>
> Melissa
>


--
Daniel da Veiga
Computer Operator - RS - Brazil
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
------END GEEK CODE BLOCK------

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=3Dgcdmw-win32@m.gmane.org

Re: Full Text Search Question

Here is the index....

create FULLTEXT index FULLTEXT_WFPRequestIDX
ON
workforceplan_request(`function`,Organization,Company,locati on,OnOffSite,project,Element);


Here is a simple query....

select * from workforceplan_request
where MATCH
(`function`,Organization,Company,location,OnOffSite,project, Element) AGAINST
('goddard')

The word Goddard is in the Location column for all records, but returns no
records with the above query.... This is the first time I've implemented
full text searching.... my developers wants a full text search similar to
Googles search.

Melissa


----- Original Message -----
From: "Daniel da Veiga"
To: "MySQL Win32 List"
Sent: Wednesday, November 23, 2005 9:06 AM
Subject: Re: Full Text Search Question


> Please post more information, like your table structure and the query
> designed to get the information, without this its kinda hard to
> recognize your problem. Full text search should get you the results no
> matter what indices and words are you looking for, as long as you use
> the LIKE statement and % on the search string.
>
> On 11/23/05, Melissa Dougherty wrote:
>> I'm new to using full text searching.... I've created an index on a
>> smaller table. I'm getting no results when a word exists in most of the
>> rows... I know this is the way it was designed, but is there thing that
>> can change it?
>>
>>
>> Melissa
>>
>
>
> --
> Daniel da Veiga
> Computer Operator - RS - Brazil
> -----BEGIN GEEK CODE BLOCK-----
> Version: 3.1
> GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V-
> PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++
> ------END GEEK CODE BLOCK------
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=melissa@cse-corp.com
>
>


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Full Text Search Question

Melissa Dougherty wrote:

> Here is the index....
>
> create FULLTEXT index FULLTEXT_WFPRequestIDX
> ON
> workforceplan_request(`function`,Organization,Company,locati on,OnOffSite,project,Element);
>
>
>
> Here is a simple query....
>
> select * from workforceplan_request
> where MATCH
> (`function`,Organization,Company,location,OnOffSite,project, Element)
> AGAINST ('goddard')
>
> The word Goddard is in the Location column for all records, but
> returns no records with the above query.... This is the first time
> I've implemented full text searching.... my developers wants a full
> text search similar to Googles search.
>
> Melissa
>
>

From the manual:

A word that matches half of the rows in a table is less likely to locate
relevant documents. In fact, it most likely finds plenty of irrelevant
documents. We all know this happens far too often when we are trying to
find something on the Internet with a search engine. It is with this
reasoning that rows containing the word are assigned a low semantic
value for /the particular dataset in which they occur/. A given word may
exceed the 50% threshold in one dataset but not another.

The 50% threshold has a significant implication when you first try
full-text searching to see how it works: If you create a table and
insert only one or two rows of text into it, every word in the text
occurs in at least 50% of the rows. As a result, no search returns any
results. Be sure to insert at least three rows, and preferably many
more. Users who need to bypass the 50% limitation can use the boolean
search mode.



You'll need to massage the query terms (try a boolean search) to get a
more Google-like response on common words.

Links of interest:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
http://dev.mysql.com/tech-resources/articles/full-text-revea led.html


kgt





--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org