From: Christoph Boget
Date: August 31 2010 6:06pm
Subject: Re: Even or Odds numbers
List-Archive: http://lists.mysql.com/mysql/222759
Message-Id: <AANLkTikLf34_-3-8u+BHkB+x7eZbOWjCRsz2Xy8DiUMu@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

> 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