> -----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, 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/mysql?unsub=arch...@jab.org