List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:April 24 2012 4:24pm
Subject:Re: Postal code searching
View as plain text  
How about if I want to only return postal codes that are like W1U 8JE
not W13 0SU.

Because in this example I have W1 as the postal code and W13 is the other
postal code


On Tue, Apr 24, 2012 at 5:18 PM, Gary Smith <lists@stripped> wrote:

> On 24/04/2012 17:16, Gary Smith wrote:
>
>> http://dev.mysql.com/doc/**refman/5.0/en/string-**
>>
> comparison-functions.html<http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html>
>>
>> Specifically, replace % with _ as this means "match one character" not
>> "match any number of characters". So, you can do:
>>
>> like "W1 %"
>> like "W1_ %"
>> etc.
>>
> Oh, and you can also get really dirty and start using string functions
> like left() and so on.
>
> Gary
>

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