Michael,
As was just discussed in this list, non-numeric strings values will also
evaluate to FALSE but if that string starts with a number, it could be
TRUE or FALSE (depending on the actual value of the numeric portion of the
string).
He never explicitly said if those were numerical fields or not (though it
is reasonable to assume they are because he is comparing them to 0 and not
'0'). So your solution is more likely than not a shorthand way of
representing a valid solution to this particular query, I must caution the
newer readers of this list against using this technique with non-numeric
fields as your answers may not agree with your expectations.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Michael Stassen <Michael.Stassen@stripped> wrote on 11/19/2004 10:02:19
AM:
> denys wrote:
>
> > SELECT country
> > FROM Rates
> > WHERE fieldvalue1 <> 0 AND fieldvalue2 <> 0 AND fieldvalue3
> <> 0
> > ORDER BY country
> > is it what you want ?
> >
>
> Gleb Paharenko wrote:
>
> > Hello
> >
> > You may use query like this:
> > select country from rates where (fieldvalue1 !=0) and (fieldvalue2
!=0)
> > and (fieldvalue3 !=0) order by country;
> >
> > See:
> > http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
>
> And since 0 is false and every other number is true, this could be
> simplified to
>
> SELECT country
> FROM Rates
> WHERE fieldvalue1 AND fieldvalue2 AND fieldvalue3
> ORDER BY country;
>
> Michael
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
>
