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 explicitly said if those were numerical fields or not (though it is reasonable to assume they are because he is comparing them to 0 and not '0'). So your solution is more likely than not a shorthand way of representing a valid solution to this particular query, I must caution the newer readers of this list against using this technique with non-numeric fields as your answers may not agree with your expectations.
Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Michael Stassen <[EMAIL PROTECTED]> wrote on 11/19/2004 10:02:19 AM:
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]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
