List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:August 31 2010 6:12pm
Subject:Re: Even or Odds numbers
View as plain text  
----- Original Message ----- 
From: "Christoph Boget" <christoph.boget@stripped>
To: "Mike Blezien" <mickalo@stripped>
Cc: "MySQL List" <mysql@stripped>
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()
> 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 :)

Thunder Rain Internet Publishing
Custom Programming & Web Hosting Services
Office: 1.712.395.0670
Skype Contact: cgimickalo

Even or Odds numbersMike Blezien31 Aug
  • RE: Even or Odds numbersJay Blanchard31 Aug
  • Re: Even or Odds numbersChristoph Boget31 Aug
  • Re: Even or Odds numbersMike Blezien31 Aug
    • RE: Even or Odds numbersDaevid Vincent31 Aug