Re: Full Text Search Question - Melissa Dougherty - com.mysql.lists.win32

4 messages in com.mysql.lists.win32Re: Full Text Search Question

From	Sent On	Attachments
Melissa Dougherty	23 Nov 2005 05:42
Daniel da Veiga	23 Nov 2005 06:05
Melissa Dougherty	23 Nov 2005 06:19
Kristen G. Thorson	23 Nov 2005 07:04

Subject:	Re: Full Text Search Question
From:	Melissa Dougherty (meli...@cse-corp.com)
Date:	11/23/2005 06:19:05 AM
List:	com.mysql.lists.win32

Here is the index....

create FULLTEXT index FULLTEXT_WFPRequestIDX ON workforceplan_request(`function`,Organization,Company,location,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

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 <meli...@cse-corp.com> 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?