Dear Experts,
Can you please advise in a basic issue, I have a Yahoo Small Business account where having a MySQL database and being able to see the records of the created table named as test1 through phpMyAdmin.
Starting from the very beginning, I am able to run the following SQL commands successfully:
SELECT * FROM test1
or also works:
SELECT * FROM `test1` WHERE `country` = 0
That is so a consequent base, but the following commands do not work any of them so the Germany word between " " or ' ' or `` :
SELECT * FROM `test1` WHERE `country` = "Germany"
SELECT * FROM `test1` WHERE `country` = 'Germany'
SELECT * FROM `test1` WHERE `country` = `Germany`
Could maybe someone has experience how it requires the syntax?
Thanks,