MySQL Error 1054

Problem, when querying data, the input string is a number, you can query, but when you enter an alphabetic string but can not query, always prompt error 1054

Workaround: Enclose the string in single quotation marks

　　field corresponding to the value if it is a character or string type, when applied in English single quotation marks, you should use the anti-quotation marks, that is, the English input method when the number 1 keys to the left of the key,
The function of this tag is to treat the content as a simple character, usually to solve the situation where the meaning of the expression conflicts with the keyword, such as CREATE table user ... Will error,
You can use CREATE table ' user ' ... or CREATE table ' table ' ...

MySQL Error 1054