Hello,
is there a function, using MySQL 5.0v, that can detect if a numerical value is
either an Even or Odd number
Thanks,
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Custom Programming Web Hosting Services
[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
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,
-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
- 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
' ?
just sayin'.
-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 christoph.bo...@gmail.com
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
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