List:General Discussion« Previous MessageNext Message »
From:Michael.Coll-Barth Date:August 31 2010 6:35pm
Subject:RE: FW: Even or Odds numbers
View as plain text  
My apologies.  With your example; SELECT MOD( X, 2 ), it will do exactly as you say it
will do.

-----Original Message-----
From: Christoph Boget [mailto:christoph.boget@stripped] 
Sent: Tuesday, August 31, 2010 2:26 PM
To: Coll-Barth, Michael
Cc: mysql@stripped
Subject: Re: FW: Even or Odds numbers

>> where X is your number (or column name).  If 0, it's even if
>> 1 it's odd.
> I think you mean, if it is non-zero, then it is odd.

If you're MODding using 2 as the second argument, it's always going to
be 0 or 1.  2 either divides in to the number evenly, having a
remainder of 0, or it'll have a remainder of 1.  The former indicates
the number is even, the latter odd.

thnx,
Christoph

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1

Thread
FW: Even or Odds numbersMichael.Coll-Barth31 Aug
Re: FW: Even or Odds numbersChristoph Boget31 Aug
RE: FW: Even or Odds numbersMichael.Coll-Barth31 Aug