Hi Dennis,
Yes, this is the way it works. You can do a match <field> against
<stringg> on whole words only. If you want to search for 'support' match
<field> against 'support' is ok, but match <field> against 'supp' will not
work. In these cases your only choice is to use where field like
'%supp%'. (As far as I know). In MySQL 4.0 the fulltext search function
will be more sophisticated.
Regards,
Peter Szekszardi
PortoLogic Ltd.
Portal building, prime number generating, script hacking and more...
The prime number of the day is 397097873
On Thu, 5 Apr 2001, Dennis S.Davidoff wrote:
> 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
