MySql Boolean Search on #/+ special characters
Posted on 2011-09-23
We need to be able to search for the + sign and # sign in MySQL using MATCH AGAINST IN BOOLEAN MODE, but these characters are not apparently searchable by default, which means we cant search for c++ or c# in boolean mode. I have gone and read the MySQL documentation on this matter but to be honest, its not in laymen's terms and I am shocked by the lack of information on this subject, I would have thought this would have been a common requirement.
I have also just found out, that if we want it to search for + and # and use UTF8 that we have to modify the source code for mysql!! Surely this cant be true? Im sure someone out there knows of a solution to this, there must be, other MySQL is apparently not the right choice here.