pulling odd numbers out of mysql

[fnsnoop]

Hi,
I have a database of numbers. I want to pull out odd numbers in a row and count how many are in a row till there is a even number. example:

45 - 67 - 71-10 - 23 - 44 3 in a row

note it will only pull out the first odd ones and stop completly so this would produce 0 in a row
10 - 29 - 2 - 99 - 37 0 in a row

this would produce the result 1

1 - 18 - 68- 29 - 82 1 in a row

I have tryed doing this for a while but i cant get it to work.

Alex

[AstroTeg]

Sounds like you just need to add in your where clause a statement to only pull out those records with an odd number. I think in MySQL you can use %, otherwise look for "mod" or modulus.