You could try with the <> operator.
!=, <>    Not equal operator

Or you could try it this way - ISNULL(col_or_data_to_check).
mysql> SELECT ISNULL(1+1);
| ISNULL(1+1) |
|           0 |
1 row in set (0.02 sec)


Chris wrote:
Chris wrote:
unknown compared to anything is unknown.

he was talking about plsql and condition evaluation (ends with true or false), your point is absolutely useless.

The context is in the database - my example is in the database. How is that useless?

In case you missed it, this is the context:

> Which only works when ShipDate was not NULL to begin with.
> I suppose it evaluates the following to FALSE
> IF NULL != '2008-10-31' AND '2008-10-31' IS NOT NULL THEN
> (not liking the "NULL != '2008-10-31'" part)
> Please give me the correct syntax.
anything compared to NULL is always false

ie - you are wrong.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to