SQL Error when saving

Can anyone shed some light on why this error is happening? Is it because the column DESC is similar to a keyword for Descending in an order by?

Error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘DESC = ‘test’ , modified = ‘2018-09-19 18:53:01’ WHERE id = 1266’ at line 1


Yes that was the issue I just went ahead and changed DESC to DESCRIPTION and that fixed the issue.

if you encounter this “problem” more often remember that you can also escape table and column names with backticks. ex.:

SELECT * FROM table WHERE `DESC` = 'test'