在mysql全文搜索中搜索特殊字符

Question

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)

Answer 1

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.