CODEWITHSUNDEEP
phpmysql
Thomas
Thomas

Reputation: 613

Search for special chars in mysql full text search

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)

Upvotes: 4

Views: 1813

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1271131

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.

Upvotes: 5

Related Questions