I was playing around with a certain query only to come up with 0 results every time. After looking around, I found that, in MySQL, the samples that actually tried to surround the table column names used the the grave symbol (`), not to be confused by the single quotes (‘). The grave symbol is found on the same button as the tilde (~).
For example, if there was a table column called Name…
Using ‘Name’ in your query would probably create 0 results.
Using `Name` in your query would probably create the desired number of results.