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.bo...@gmail.com] Sent: Tuesday, August 31, 2010 2:26 PM To: Coll-Barth, Michael Cc: mysql@lists.mysql.com 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=michael.coll-ba...@verizonwireless.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
