phpMyAdmin keeps throwing error #1064

Question

Here's the error warning I get when executing my query:

My database structure:

Can anyone help me find the error?

Answer 1

CHARACTER is a reserved MySQL keyword, try putting it in quotes:

SELECT name FROM `CHARACTER`