Re: [PHP-DB] 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.
>