John Taylor-Johnston wrote:
In php, if I wanted to know if $mydata->email contained something, I
would do this, right?
if ($mydata->email)
{}
How would I express this in SQL (MySQL)?
That doesn't tell you if $mydata->email contains something. It tells you
whether the value of $mydata->email, when cast to boolean, equals TRUE.
If $mydata->email equaled zero or the string "0", it would still contain
something, but that if statement would not get executed.
In MySQL, it would depend on the datatype. You could do any of the
following, depending on what you actually want to do:
colname<>''
colname<>0
colname IS NOT NULL
Or, if you're in MySQL >= 5.0.2 and are using true boolean values:
colname IS TRUE
or, if you just want to check if it's TRUE or UNKNOWN:
colname IS NOT FALSE
Jasper
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
