query to match 3rd + 4th entries

[v3nt]

i need to search some postcodes in a table. the 1st 2 characters are always BT,

so i only need to match the 3rd (BT1-9) and then the 3rd and 4th(BTXX).
all th post codes are in BTX XXX, or BTXX XXX format.

is something like this possible?

$query_PD = "SELECT * FROM property WHERE pavailable ='1' AND synchDel !='1'
AND  (ppostcode[2]='1' OR ppostcode[2]='2'.....)

ORDER BY $ordercrit";

whats the best way to do this?
thanx....

[sneakyimp]

this question would probably be much better answered in the database section of this forum.

That said--and i'm no expert here--I might recommend some kind of pattern matching or wildcard in the WHERE clause.

[kburger]

Check out LIKE from the MySQL manual.