List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:April 24 2012 4:11pm
Subject:Postal code searching
View as plain text  
Hi

I've a number of different postal codes in a system for example

WC1B 5JA
WC1H 8EJ
W1J 7BX
W1H 7DL
NW1 1NY

I can use like statements for example

SELECT * FROM postal_codes WHERE zip LIKE 'W1%' giving me

W1J 7BX
W1H 7DL

In addition I have a number of abbreviated postal codes like

W1
WC1
WC2
NW1

Now, if I know the postal code W1J 7BX what is the best way using a MySQL
query to get the abbreviated postal codes W1.  Same if I have the postal
code WC1H 8EJ, how do I get the abbreviated postal codes WC1

Can I use any matching patterns ?

Thanks,
Neil

Thread
Postal code searchingTompkins Neil24 Apr
  • Re: Postal code searchingGary Smith24 Apr
    • Re: Postal code searchingGary Smith24 Apr
      • Re: Postal code searchingTompkins Neil24 Apr
        • Re: Postal code searchingGary Smith24 Apr
        • Re: Postal code searchingLars Nilsson24 Apr
        • Re: Postal code searchingMark Goodge25 Apr
          • Re: Postal code searchingAndrew Moore25 Apr
          • Re: Postal code searchingTompkins Neil25 Apr
          • Re: Postal code searchinghsv25 Apr
          • Re: Postal code searchinghsv25 Apr
  • RE: Postal code searchingRick James24 Apr
    • Re: Postal code searchingNeil Tompkins24 Apr
      • Re: Postal code searchingGrant Allen24 Apr