I tried to do a command to remove LORE from all items using what I have been learning here but I failed. I typed UPDATE items lore = 0 WHERE lore = 1; but I got an error on syntax. Any idea what I did wrong? apparently quotation marks aren't necessary for my version of MySQL.
|