MYSQL syntax not evaluating not equal to in presence of NULL

by

use IS NULL or IS NOT NULL to compare NULL values because they are simply unknown.

SELECT name 
from   products p
WHERE  backorder IS NULL OR backorder <> 2

More Related Contents:

  1. How can I return pivot table output in MySQL?
  2. Using LIMIT within GROUP BY to get N results per group?
  3. How to perform grouped ranking in MySQL
  4. Required to join 2 tables with their FKs in a 3rd table
  5. MySQL Trigger after update only if row has changed
  6. Does COUNT(*) always return a result?
  7. Ordering by specific field value first
  8. MySQL “Group By” and “Order By”
  9. How to change the CHARACTER SET (and COLLATION) throughout a database?
  10. MySQL Query to select data from last week?
  11. Connect By Prior Equivalent for MySQL
  12. Mysql::Error: Specified key was too long; max key length is 1000 bytes
  13. How to convert all tables from MyISAM into InnoDB?
  14. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  15. Are there disadvantages to using a generic varchar(255) for all text-based fields?
  16. SQL Query to show nearest date?
  17. How to create relationships in MySQL
  18. Getting all parent rows in one SQL query
  19. Mysql Improve Search Performance with wildcards (%%)
  20. ALTER TABLE to add a composite primary key
  21. Second SELECT query if first SELECT returns 0 rows
  22. Difference between two table structure
  23. Difference between SET autocommit=1 and START TRANSACTION in mysql (Have I missed something?)
  24. How to retrieve JSON data from MySQL?
  25. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  26. Why MySQL is giving error “Not allowed to return a result set from a function”?
  27. When to use a left outer join?
  28. Optimistic locking in MySQL
  29. Insert and set value with max()+1 problems
  30. comparison of truncate vs delete in mysql/sqlserver [duplicate]

Leave a Comment