Why use a cannon on a gnat?
Your data is already in an Excel spreadsheet, so why not use Excel to do
Will be true if the street number is odd; then you can just filter on that
column to select the "TRUE" rows, and copy them to wherever you need them.
>From: Jason Pruim [mailto:japruim@stripped]
>Sent: Monday, February 02, 2009 1:27 PM
>Subject: grabbing even addresses?
>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:
>and what I want out of those would be:
>Any ideas? Thanks for looking! :)