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
Hi Jason,
On Mon, Feb 2, 2009 at 7:27 PM, Jason Pruim japr...@raoset.com wrote:
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
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:
-Original Message-
From: Jason Pruim [mailto:japr...@raoset.com]
Sent: Monday, 02 February 2009 13:27
To: mysql@lists.mysql.com
Subject: grabbing even addresses?
Hello!
I was wondering if something was possible, I have an excel
file right now of US mailing addresses
not necessarily endorse content contained within this transmission.
To: mysql@lists.mysql.com
From: japr...@raoset.com
Subject: grabbing even addresses?
Date: Mon, 2 Feb 2009 13:27:26 -0500
Hello!
I was wondering if something was possible, I have an excel file right
now of US mailing
On Mon, Feb 2, 2009 at 13:43, Martin Gainty mgai...@hotmail.com wrote:
select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_
NUMBER(SUBSTR(ADDRESS,1,instr(ADDRESS,' ',1))),2) =0;
That hit the nail right on the head. That was the same thing I
was going to suggest, Martin. I think people tend to
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
.
-Original Message-
From: Jason Pruim [mailto:japr...@raoset.com]
Sent: Monday, February 02, 2009 1:27 PM
To: mysql@lists.mysql.com
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