-Original Message-
> From: Mike Blezien [mailto:mick...@frontiernet.net]
> Sent: Tuesday, August 31, 2010 11:13 AM
> To: jcbo...@yahoo.com
> Cc: MySQL List
> Subject: Re: Even or Odds numbers
>
> - Original Message -
> From: "Christoph Boget"
> To: &
- Original Message -
From: "Christoph Boget"
To: "Mike Blezien"
Cc: "MySQL List"
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 Ev
> 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
[snip]
is there a function, using MySQL 5.0v, that can detect if a numerical
value is
either an Even or Odd number
[/snip]
You can use modulus
http://www.roseindia.net/sql/mysql-example/mysql-modulus.shtml
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscr
