Read the manual, the most frequent words are stopped in index.
Chai-Hup Chen wrote:
> Hi,
> Thanks a lot, the select is much faster now. But I find something
> weird, it return nothing when match against the string "the", which
> return 255568 entries when select "% the %", is it possible mysql
> does not indexed some words for some reason?
>
>
> select count(*) from Books where match Title against ('cisco');
> +----------+
> | count(*) |
> +----------+
> | 222 |
> +----------+
> 1 row in set (1.76 sec)
>
>
>
>
> select count(*) from Books where Title like "% the %";
> +----------+
> | count(*) |
> +----------+
> | 255568 |
> +----------+
> 1 row in set (1 min 23.17 sec)
>
> select count(*) from Books where match Title against ('the');
> +----------+
> | count(*) |
> +----------+
> | 0 |
> +----------+
> 1 row in set (0.00 sec)
>
>> SELECT count(*) FROM Books WHERE MATCH Title AGAINST 'cisco'
>>
>> We use a FULLTEXT index search in a couple of our table for business referral
>> searches, and it works like a charm!
>>
>> Hope this helps
>>
>>>> Hi,
>>>> Here is the fulltext index I add:
>>>>
>>>> CREATE TABLE Books (
>>>> isbn char(10) NOT NULL default '',
>>>> Title char(255) NOT NULL default '',
>>>> FULLTEXT KEY full_title (Title)
>>>> ) TYPE=MyISAM;
>>>>
>>>> select count(*) from Books --> 2028971
>>>> select count(*) from Books where Title like "% cisco %"
>>>> +----------+
>>>> | count(*) |
>>>> +----------+
>>>> | 86 |
>>>> +----------+
>>>> 1 row in set (1 min 15.58 sec)
>>>>
>>>> Look like the fulltext index is not functioning ... Any idea?
>>>
>> Mike(mickalo)Blezien
>> ========================================
>> Thunder Rain Internet Publishing
>> Providing Internet Solutions that work!
>> http://www.thunder-rain.com
>> Tel: 1(225) 686-2002
>> =========================================
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> ---------------------------------------------------------------------
>> Before posting, please check:
>> http://www.mysql.com/manual.php (the manual)
>> http://lists.mysql.com/ (the list archive)
>>
>> To request this thread, e-mail <[EMAIL PROTECTED]>
>> To unsubscribe, e-mail <[EMAIL PROTECTED]>
>> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
--
--
Antonio Gulli' Ideare S.p.a tel: (+39) 050 575300
[EMAIL PROTECTED] Lungarno Mediceo 56 fax: (+39) 050 575583
whois: AG2-ORG I-56126 Pisa, Italy http://www.ideare.com net:
print pack"C*",split/\D+/,`echo "16iII*o\U@{$/=$z;[(pop,pop,unpack"H*",<>
)]}\EsMsKsN0[lN*1lK[d2%Sa2/d0<X+d*lMLa^*lN%0]dsXx++lMlN/dsM0<J]dsJxp"|dc`