Hi, all.
I'm a newbie so be gentle
I have a quastion about new feature of MySQL - Full-text indexing
(http://www.mysql.com/doc/M/y/MySQL_full-text_search.html). Cutting: "Since
Version 3.23.23, MySQL has support for full-text indexing and searching.
Full-text indexes in MySQL are an index of type FULLTEXT...". Well, when I
trying to search in my tables (see example on url:
http://www.mysql.com/doc/M/y/MySQL_full-text_search.html) some words such
like these: "support", "vector" or else... I have find it... but when I'll
trying to search words: "suppo" or "vect" - I can't find any of these words
("support", "vector"), i.e. relevance is zero. As I think I could use LIKE
"%suppo%", but what about full-text searching? Could I use full-text
indexing for search words like "supp"?
SELECT *,MATCH a,b AGAINST ('$searching') as x FROM t;
Please, help me.
Digitally yours,
Dennis
---------------------------------------------------------------------
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
