From: Martin Gainty Date: February 2 2009 6:43pm Subject: RE: grabbing even addresses? List-Archive: http://lists.mysql.com/mysql/216130 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="_5014c830-4eea-4bd6-aff8-bad10448c361_" --_5014c830-4eea-4bd6-aff8-bad10448c361_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Jason try select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_ NUMBER(SUBSTR(ADDRESS=2C1=2Cinstr(ADDRESS=2C' '=2C1)))=2C2) =3D0=3B SUBSTR(ADDRESS=2C1=2CINSTR(ADDRESS=2C''=2C1)) ---------------------------------------------------------------------------= ----- 1232 Main=20 1234 Main HTH Martin=20 ______________________________________________=20 Disclaimer and confidentiality note=20 Everything in this e-mail and any attachments relates to the official busin= ess of Sender. This transmission is of a confidential nature and Sender doe= s not endorse distribution to any party other than intended recipient. Send= er does not necessarily endorse content contained within this transmission.= =20 > To: mysql@stripped > From: japruim@stripped > Subject: grabbing even addresses? > Date: Mon=2C 2 Feb 2009 13:27:26 -0500 >=20 > Hello! >=20 > I was wondering if something was possible=2C I have an excel file right = =20 > now of US mailing addresses=2C and what I need to do is select all the =20 > odd numbered addresses on one road=2C is there an easy way I can do =20 > that from MySQL? the addresses could contain 3=2C 4 or 5 numbers per =20 > addresses such as: >=20 > 123 Main > 1232 Main > 1233 Main > 1234 Main > 12345 Main >=20 > and what I want out of those would be: >=20 > 1232 Main > 1234 Main >=20 > Any ideas? Thanks for looking! :) >=20 >=20 > -- > Jason Pruim > japruim@stripped > 616.399.2355 >=20 >=20 >=20 _________________________________________________________________ Windows Live=99 Hotmail=AE:=85more than just e-mail.=20 http://windowslive.com/explore?ocid=3DTXT_TAGLM_WL_t2_hm_justgotbetter_expl= ore_012009= --_5014c830-4eea-4bd6-aff8-bad10448c361_--