> AFAIK you are right - MySQL treats a hypen as a word-break. And, AFAIK you
cannot modify that behaviour.
>
> The only possibility, I think, would be to modify the source and compile
your own MySQL. :-(
>
> However if you do a full-text search using IN BOOLEAN MODE, then you can
put quotes around hypenated words.
>
> ... MATCH (col_name) AGAINST ('"s-au"' IN BOOLEAN MODE) ...
>
> HTH,
> James Harvard
I have tried that, but it doesn't found anything. I think this is because
MySQL doesn't put the words "s" and "au" in the fulltext index at all, so it
is not able to find "s-au".
Isn't possible to set somewhere which are the "word" chars?
I am not sure how other special chars (which are real chars) like s, t, â,
a, î, S, T, Â, Î, A are viewd by MySQL fulltext index... as "word" chars, or
as "word break" chars.
If I could add some of these chars, maybe I could also add the "-"
character.
Teddy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
