Re: php explained in sql

We should use: if (!empty($mydata->email)) in php, right? On 8/19/05, Jasper Bryant-Greene <jasper@bryant-greene.name> 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 > > -- Jose Arce http://sinexion.com - http://josearce.com