varchar:
colname<>''
Thanks,
John
Jasper Bryant-Greene wrote:
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