----- Original Message -----
From: "Christoph Boget" <christoph.bo...@gmail.com>
To: "Mike Blezien" <mick...@frontiernet.net>
Cc: "MySQL List" <mysql@lists.mysql.com>
Sent: Tuesday, August 31, 2010 1:06 PM
Subject: Re: Even or Odds numbers
is there a function, using MySQL 5.0v, that can detect if a numerical value
is either an Even or Odd number
MOD()
http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_mod
SELECT MOD( X, 2 )
where X is your number (or column name). If 0, it's even if 1 it's odd.
thnx,
Christoph
Thanks that should do the trick. Appreciate the other response too. Big help :)
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
http://www.thunder-rain.com/
Office: 1.712.395.0670
Skype Contact: cgimickalo
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org