I am trying to do a user search based on full-text search.
SELECT * FROM users WHERE MATCH (name) AGAINST ('FDR' in BOOLEAN MODE);
However, the query yields no results. I can replace the search value with other lines and give results.
I even tried using a null list of words without success. The problem is with this particular line.
source
share