Very strange problem

#1

I have a column in a table that is configured for full text searching.
I can search the DB with this:

SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST
('"add"' IN BOOLEAN MODE);

It will not return results when searching for the work "add" or ("Add"
or any other variant). It can find phases that include the word "add"
like this:

SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST
('"add to base"' IN BOOLEAN MODE);

That works fine. It can also find records with any other single word
that I've tested. I'm using the command line interface in Linux and
using the Query Browser Client in windows with the same results. Any
idea what's going on here? What am I missing?

#2

Bruce wrote:

Quote:

I have a column in a table that is configured for full text searching.
I can search the DB with this:

SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST
('"add"' IN BOOLEAN MODE);

It will not return results when searching for the work "add" or ("Add"
or any other variant). It can find phases that include the word "add"
like this:

SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST
('"add to base"' IN BOOLEAN MODE);

That works fine. It can also find records with any other single word
that I've tested. I'm using the command line interface in Linux and
using the Query Browser Client in windows with the same results. Any
idea what's going on here? What am I missing?

You're missing that bit where you read the manual and it says:
"The default minimum value is four characters;"

#3

Yep, I missed that. Thanks.

Paul Lautman wrote:

Quote:

Bruce wrote:
I have a column in a table that is configured for full text searching.
I can search the DB with this:

SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST
('"add"' IN BOOLEAN MODE);

It will not return results when searching for the work "add" or ("Add"
or any other variant). It can find phases that include the word "add"
like this:

SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST
('"add to base"' IN BOOLEAN MODE);

That works fine. It can also find records with any other single word
that I've tested. I'm using the command line interface in Linux and
using the Query Browser Client in windows with the same results. Any
idea what's going on here? What am I missing?

You're missing that bit where you read the manual and it says:
"The default minimum value is four characters;"

#4

Bruce wrote:

Quote:

Yep, I missed that. Thanks.

Paul Lautman wrote:
Bruce wrote:
I have a column in a table that is configured for full text
searching. I can search the DB with this:

SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST
('"add"' IN BOOLEAN MODE);

It will not return results when searching for the work "add" or
("Add" or any other variant). It can find phases that include the
word "add" like this:

SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST
('"add to base"' IN BOOLEAN MODE);

That works fine. It can also find records with any other single word
that I've tested. I'm using the command line interface in Linux and
using the Query Browser Client in windows with the same results.
Any idea what's going on here? What am I missing?

You're missing that bit where you read the manual and it says:
"The default minimum value is four characters;"

Be sure and read the next bit that says that you can change this value.

#5

I changed the variable and it worked. Thanks for you help!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Very strange problem

comp.databases.mysql comp.databases.mysql

Very strange problem - 01-09-2007 , 02:45 PM

Re: Very strange problem - 01-09-2007 , 03:01 PM

Re: Very strange problem - 01-10-2007 , 07:34 AM

Re: Very strange problem - 01-10-2007 , 07:35 AM

Re: Very strange problem - 01-10-2007 , 08:13 AM