mysql 特殊字符处理,处理MySQL全文特殊字符

When using MySQL full text search in boolean mode there are certain characters like + and - that are used as operators. If I do a search for something like "C++" it interprets the + as an operator. What is the best practice for dealing with these special characters?

The current method I am using is to convert all + characters in the data to _plus. It also converts &,@,/ and # characters to a textual representation.

解决方案

There's no way to do this in nicely using MySQL's full text search. What you're doing (substituting special characters with a pre-defined string) is the only way to do it.

You may wish to consider using Sphinx Search instead. It apparently supports escaping special characters, and by all reports is significantly faster than the default full text search.