I am using php my admin to test my query and when I test a simple query like:
SELECT * FROM song WHERE title LIKE '%anytitle%'
It returns an empty result. With any title it gives me the same thing.
If i try the same thing on my other table users
SELECT * FROM users WHERE email LIKE '%gmail%'
It works and return all record containing gmail.
The table are built the same, utf8_unicode_ci and VARCHAR.
What could be the problem?
edit:
I destroyed my table and I have rebuild it.I have executed the query with just one row in the table and it worked. I've repopulated the table and now it does not work.
I have 5029 records in the table. Would it be a setting somewhere?
Re edit: When I try like
SELECT * FROM song WHERE title LIKE '%d%'
It return every record where there is a d inside the title name. But if I try with more than one letter it does not work, I have no result.
I've updated mysql, I've unistalled it and installed version 5.6 instead and still the same issue.