MySQL WHERE how to write or not equals

Question

I need to do this  DELETE FROM konta WHERE taken         But    doesn t exist in mysql  Anyone know how to do this

User · Accepted Answer

DELETE FROM konta WHERE taken  lt  gt

User · Answer

You may be using old version of Mysql but surely you can use    DELETE FROM konta WHERE taken  lt  gt       But there are many other options available  You can try the following ones  DELETE   from konta WHERE strcmp taken       lt  gt  0   DELETE   from konta where NOT  taken

User · Answer

The    operator most certainly does exist  It is an alias for the standard  lt  gt  operator   Perhaps your fields are not actually empty strings  but instead NULL   To compare to NULL you can use IS NULL or IS NOT NULL or the null safe equals operator  lt   gt

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

Examples related to mysql

Examples related to sql-delete