I'm having a problem with MySQL full text search. I have a
users table that has a single column,
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.