On Feb 2, 2009, at 1:41 PM, Christoph Boget wrote:
>> 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! :)
>
> Well, if this is something you will be doing a lot, the most efficient
> way to store the addresses would be to have separate columns for the
> house number and the street name. Doing that will allow you to run a
> query as simple as:
>
> SELECT * FROM Addresses WHERE (house_number % 2) == 0;
>
> If you can't (or don't want to) have separate columns, you can use a
> regular expression to pull out the house number then operating on it
> as above. You can read more about mysql and regular expressions
> here:
>
> http://dev.mysql.com/doc/refman/5.0/en/regexp.html
Hi Chris,
Thanks for the info, I had thought about splitting it but wanted to
see if there was a better/different way. Right now this is a one
time thing, but if it works well it's something that could turn into
a regular thing for me to do.
Thanks again!
--
Jason Pruim
japruim@stripped
616.399.2355
