Michael,
have a look at the sources, especially myisam/ft_parser.c near line 108
and at myisam/ftdefs.h. It should not be difficult to hack the sources to
make the hyphen a real character. This will solve your problem (but could
create some new ones on others types of text input).
Thomas
On Wed
Sorry about this,
> The only way to search for kk-4835 is to do the
> search
> in Boolean mode and put things in quotes ->
> "kk-4835"
> So your query would look like this:
>
> > SELECT * FROM ms_items
> > where MATCH (it_mnfgID, it_title, it_descrip)
> > AGAINST ('"kk-4835"' IN BOOLEAN MODE )
P
Hello,
Fulltext section of mysql manual: "MySQL uses a very
simple parser to split text into words. A "word" is
any sequence of characters consisting of letters,
digits, " ' ", and " _ ". Any "word" that is present
in the stopword list or is just too short is ignored."
Thus a hyphen would be vi
In the last episode (Dec 31), michael elston said:
> I am having some trouble with fulltext search when searching a Table
> for parts numbers which contain HYPHENS ( - ) and i am 90% sure that is
> where the problem is.
>
> My query is:
> SELECT * FROM ms_items
> where MATCH (it_mnfgID, it_title
I am having some trouble with fulltext search when searching a Table
for parts numbers which contain HYPHENS ( - ) and i am 90% sure that is
where the problem is.
My query is:
SELECT * FROM ms_items
where MATCH (it_mnfgID, it_title, it_descrip) AGAINST ('*kk-4835*' IN
BOOLEAN MODE )
What i wan