Re: Mysql Match+Against doesnt see @

[Barry Galbraith]

I see what you mean.

All can suggest is file a bug report. http://bugs.mysql.com

Edit:

It seems this is covered in the refman

http://dev.mysql.com/doc/refman/5.6/en/full-text-adding-collation.html

You'll need to change the ctype for @ char for your (user_defined) collation.

Edit2:

When you make @ a normal character instead of punctuation in your new collation, you don't get the results you think you should.
Looking for '@microsoft.com' returns 0 rows because you are now only looking at part of a word. It would need for @microsoft.com to be surrounded by puctuation or whitespace to be found.
You need a diffent method to find what you want.

Good luck,
Barry.



Edited 2 time(s). Last edit at 02/25/2014 05:12PM by Barry Galbraith.