Posted by Gleep on 05/27/07 18:13

On Sun, 27 May 2007 16:46:34 GMT, joboils@hotmail.com wrote:

>On Sun, 27 May 2007 00:31:45 +0100, "peter" <submit@flexiwebhost.com>
>wrote:
>
>>> I've inherited a php/mysql app which sorts and displays UK postcodes.
>>> When sorting, it uses
>>> SELECT... WHERE postcode like "$postcode%"
>>> and for a $postcode of, say E, this works Ok except it brings to
>>> screen everything starting EH (for Edinburgh) *and* everything
>>> starting E (for East London). I need to refine this further. How do
>>> I bring to screen *only* those starting, say, E (for East London), S
>>> for Sheffield and G for Glasgow, etc?
>>> I think I need to be able to ignore any postcode whose second letter
>>> is *not* a letter but is a number or space, or blank, but I don't know
>>> how to do this.
>>
>>You can use regular expressions in mysql queries. Which could be 1 way of
>>doing what you wish.
>>
>Thank you for your response. Someone else mentioned the ctype_***()
>functions and they look just the job.


wait think the last post was wrong
try
where postcode REGEXP '^$postcode( |\d)';

you should also consider string case

$postcode = strtoupper($postcode);
select ..... WHERE UPPER(postcode) REGEXP '^$postcode( |\d)' ;

[Back to original message]