not equal to blank in mysql 1

not equal to blank in mysql

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

Here is what the above code is Doing:
1. We’re selecting the name column from the products table.
2. We’re filtering the results to only include rows where the backorder column is either NULL or not equal to 2.

Similar Posts