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 · Answer

You may be using old version of Mysql but surely you can use

 DELETE FROM konta WHERE taken <> ''

But there are many other options available. You can try the following ones

DELETE * from konta WHERE strcmp(taken, '') <> 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

User · Answer

DELETE FROM konta WHERE taken  lt  gt

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

Examples related to mysql

Examples related to sql-delete