> -----Original Message----- > From: Christoph Boget [mailto:christoph.bo...@gmail.com]
> 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. I think you mean, if it is non-zero, then it is odd. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org