Re: MySQL Conditional Trigger

You could try with the <> operator.

!=, <>    Not equal operator

Or you could try it this way - ISNULL(col_or_data_to_check). Example: mysql> SELECT ISNULL(1+1); +-------------+ | ISNULL(1+1) | +-------------+

|           0 |

+-------------+ 1 row in set (0.02 sec) Aleksander 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. TIA anything compared to NULL is always false ie - you are wrong.