RE: Fulltext search dilemma (IN BOOLEAN MODE)

2007-02-01 Thread Jerry Schwartz
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. The asterisk operator is only valid at the end of a word. Those initial asterisks, and the quotation marks, would be

RE: Fulltext search dilemma (IN BOOLEAN MODE)

2007-02-01 Thread Andreas Iwanowski
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

RE: Fulltext search dilemma (IN BOOLEAN MODE)

2007-02-01 Thread Jerry Schwartz
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

RE: Fulltext search dilemma (IN BOOLEAN MODE) [RESOLVED]

2007-02-01 Thread Andreas Iwanowski
, 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