[FIXED] This simple sql query yields empty result

Issue

I am using PhpMysql and this simple query yields an empty result ("MySQL returned an empty result set").

Here is the query: SELECT * FROM TABLE 2 WHERE prenom LIKE '%Scott%'

My table has a row called prenomand there is a 'Scott' value. I have tried with other first names (which I know are in the database) and it does not work either.

The strange thing is that when I use the wildcards between One letter only i.e: SELECT * FROM TABLE 2 WHERE prenom LIKE '%S%' it works..

I need help please!

Solution

Ok so the pb was that due to the collation type instead of SCOTT, the file was encoded with spaces S C O T T. I had to reformat the file in utf8 to fix this!

Answered By - Arnaud Martinn