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