> > 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
> >
> >
>
> I will go to bed less fool this evening... Is it ju
Bulant Denys wrote:
--- Michael Stassen <[EMAIL PROTECTED]> a
écrit :
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 coun
Good point.
Michael
[EMAIL PROTECTED] wrote:
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
--- Michael Stassen <[EMAIL PROTECTED]> a
écrit :
> 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
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 field
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 (fieldv
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 <[EMAIL PROTECTED]> wrote:
> Im trying not to list
Louie Miranda a écrit :
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 fr
