List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:November 19 2004 8:12am
Subject:Re: detect rows that has zero values
View as plain text  
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

 
 Louie Miranda <lmiranda@stripped> wrote:
> Im trying not to list the rows that has zero values.
> 
> this is my current select statement:
> 
> select id,country_city from rates_ocean order by country_city
> 
> The fields that i have to detect are:
> 
> fieldvalue1
> fieldvalue2
> fieldvalue3
> 
> how can i do this on mysql, ex:
> 
> select country from rates (if fieldvalue1,fieldvalue2,fieldvalue3 = 0
> (do not display)) order by country;
> 


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



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