Re: detect rows that has zero values

[Michael Stassen]

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