MySQL Error: #1054 - Unknown column in 'field list'

I am having a strange error in mysql that despite 开发者_JS百科of existing the column it generates and error saying that the column does not exists.

This is the table schema:

This is the Error in query:

go to that table structure, edit the field.. there may b space before and after attribute name

Seems that the column does not exist. Try to execute a 'desc user_ads' to check whether the column has indeed been removed or not.

Try to do a dump of the database in order to see the data structure. For doing that you can use the mysqldump command. Take a look at the ouput of this command.

Should there be imagepath != 'NA' in mysql sql language? I would prefer <> 'NA'