I am doing a search function in php, and I am allowing BOOLEAN search, but when I enter text containing chars like @, the query fails.
For example, when I search for @everyone, it throws an error.
I tried to solve this by adding doublequotes, but it doesn't work as expected, since for the search @everyone, it works but returns rows containing everyone and @everone.
I would like to know how we can search for words containing special chars in mysql full text search
Here's my query (simplified) :
SELECT * FROM messages WHERE MATCH(body) AGAINST ('@everyone' IN BOOLEAN MODE)
解决方案
By default, MySQL does not treat '@' as a valid character for a word. If you want to treat '@' it, then review the documentation on the subject.
After you have made the changes, then you will need to re-build your index.