|
|
Posted by leader on 05/19/07 04:40
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.
Any help gratefully received.
Navigation:
[Reply to this message]
|