> -----Original Message-----
> From: Jason Pruim [mailto:[email protected]]
> Sent: Monday, 02 February 2009 13:27
> To: [email protected]
> Subject: grabbing even addresses?
>
> Hello!
>
> I was wondering if something was possible, I have an excel
> file right now of US mailing addresses, and what I need to do
> is select all the odd numbered addresses on one road, is
> there an easy way I can do that from MySQL? the addresses
> could contain 3, 4 or 5 numbers per addresses such as:
>
> 123 Main
> 1232 Main
> 1233 Main
> 1234 Main
> 12345 Main
>
> and what I want out of those would be:
>
> 1232 Main
> 1234 Main
>
> Any ideas? Thanks for looking! :)
>
If this is in excel, perhaps you'd want to pre-process this before it
gets to MySQL? e.g., in python:
isodd = int(address.split(" ")[0]) % 2
In general, you have to split the string, and test the numerical value
(modulo).
..Tom
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
