Search code examples
mysqlsql-delete

MySQL WHERE: how to write "!=" or "not equals"?


I need to do this

DELETE FROM konta WHERE taken != ''

But != doesn't exist in mysql. Anyone know how to do this?


Solution

  • DELETE FROM konta WHERE taken <> '';