Hello Jeff,
Monday, June 16, 2003, 1:13:27 PM, you wrote:
JS> On Mon, 16 Jun 2003 12:45:53 -0400, Martin's - Web Dept. wrote:
>> I am quite willing to acknowledge that I'm new at this ...
>>
>> But I can't find the syntax error in this query:
>>
>> SELECT * FROM products WHERE MATCH (desc) AGAINST ('usb')
>>
>> desc is a field name, usb is the keyword I'm searching for.
JS> As mentioned in another post desc is a reserved work and needs to be
JS> enclosed in back ticks like `desc`.
JS> Also, your select still won't return any rows because you are searching
JS> for 'usb' which is three characters and the default minimum word length
JS> for fulltext searches is 4 characters.
JS> You may want to read:
JS> http://www.mysql.com/doc/en/Fulltext_Search.html
JS> and
JS> http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html
JS> If you need to search for 3 character words, you need change your
JS> my.cnf file to contain the following:
JS> set-variable = ft_min_word_len=3
JS> And restart the MySQL server.
>>
>> MYSQL version 4.0.12
>>
>> Thanks for your help.
>>
>> Ryan
>>
>>
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
JS> ---
JS> Listserv only address.
JS> Jeff Shapiro
Thanks - that last part was what I was waiting for :)
Just had a pile of PHP/MySQL books delivered (incl MySQL 2nd Ed) , too, so hopefully I
can
cut back on these dumb errors :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
