I'm having a problem with MySQL full text search. I have a users table that has a single column, username.

The problem appears when I'm trying to search for a user with a special character (') in its name. Let's say the name is Dan v׳ila, when searching for "dan" alone it finds the result but as soon as I'm searching for "dan v" it won't show the name with the ' in it.

Examples of queries follow:

Returns the result:

Select * from uses
Match(username) against('+dan*' in boolean mode)

Doesn't return the result:

Select * from users 
Match(username) against ('+dan* +v*' in boolean mode)

It is worth noting that names without ' are showing in both cases.

| improve this question | | | | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.