On Sat, 31 Mar 2001 12:39:59 -0800 (PST), Chai-Hup Chen <[EMAIL PROTECTED]> wrote:
I think if you take a look at the MySQL docs on FULLTEXT it'll explain it alot
better then I probably could.
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html
>> 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
>>> =========================================
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
