List:General Discussion« Previous MessageNext Message »
From:Michael Stassen Date:November 19 2004 3:02pm
Subject:Re: detect rows that has zero values
View as plain text  
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

Thread
detect rows that has zero valuesLouie Miranda19 Nov
  • Re: detect rows that has zero valuesdenys19 Nov
  • Re: detect rows that has zero valuesGleb Paharenko19 Nov
    • Re: detect rows that has zero valuesMichael Stassen19 Nov
      • Re: detect rows that has zero valuesSGreen19 Nov
        • Re: detect rows that has zero valuesMichael Stassen19 Nov
      • Re: detect rows that has zero valuesBulant Denys19 Nov
        • Re: detect rows that has zero valuesMichael Stassen19 Nov
        • Re: detect rows that has zero valuesMartijn Tonies19 Nov