Finally got this thing figured out. It involved changing Collations on all of the columns in the database.
I moved databases a while ago, and now my search queried in the “Keyword” search on my music section have become case-sensitive. This is bad.
Can you help?
Here is the query as it is now (searching on “test”):
FROM pieces p, genre g, collections c
WHERE p.genre = g.id
AND c.code = p.collection
AND MATCH( title, instruments, description, feel, isrc )
AGAINST ("+test" in boolean mode)