Hello MySQL experts,
I'm trying to do a full text search on an indexed Keywords column that
contains quotation marks, and it's giving me a headache.
Suppose there are records in the database containing the folling
keywords:
1. Miami Beach City
2. Key West Florida
3. Key West Beach Florida
Now I
.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
-Original Message-
From: Andreas Iwanowski [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 12:49 PM
To: mysql@lists.mysql.com
Subject: Fulltext search dilemma (IN BOOLEAN MODE)
Hello MySQL experts,
I'm trying to do
01, 2007 1:52 PM
To: Andreas Iwanowski; mysql@lists.mysql.com
Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE)
Unless you changed the minimum word length, Key would be ignored
because it is too short. I would think the quotation marks at the start
or end of the words would be ignored
PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE)
Hi, thank you for your reply.
I have used the option ft_min_word_len=3.
If I have something like
1. Key West
in the database and I do a
SELECT * FROM my_table WHERE MATCH(Keywords
, the server was always shut
down properly.
-Andy
-Original Message-
From: Jerry Schwartz [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 4:10 PM
To: Andreas Iwanowski
Cc: mysql@lists.mysql.com
Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE)
Sorry, I have no idea what