My query: DELETE FROM 014_terms WHERE term_id IN (SELECT term_id FROM 014_term_taxonomy WHERE taxonomy LIKE 'pa_%'); Gets an error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'WHERE term_id IN (SELECT term_id FROM 014_term_taxonomy WHERE taxonomy LIKE '...' at line 1 Any ideas what is causing the error?
Generally the 1064 error displays any time you have an issue with your SQL syntax, and is often due to using reserved words, missing data in the database, or mistyped/obsolete commands. As per me query syntax do not have any problem. For crosscheck you can use the following websites & check the syntax error i.e 1) https://www.piliapp.com/mysql-syntax-check/ 2) https://www.eversql.com/sql-syntax-check-validator/ I would suggest to go SQL manual UI and check the query again. I hope it would help .. !!