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/[EMAIL PROTECTED]