MySQL Forums
Forum List  »  Full-Text Search

trying to match zipcodes for GEO region
Posted by: Jay Cohen
Date: June 04, 2012 01:54PM


I am sorry if this seems a bit basic. I did search the archives and I don't see any answers.

I have a large mailing list (approx 670,000 records). I am working on the comand line and would like something like this. But not sure I know how to do it.

select zipcode from table where zipcode (this is my problem)

I want to match the first 3 digits to the zipcodes in the database for each town.

I have tried using substring and not sure how to use strcmp and like.

Help me please.


Options: ReplyQuote

Written By
trying to match zipcodes for GEO region
June 04, 2012 01:54PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.