> 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 thnx, Christoph -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
