MySQL Select help needed

Hi All,

Trying to work out the correct sql statement

If I have a table that contains the column partpostcode and has these entries,
PE10
PE15
PE1

What I want to do is select those rows where the partpostcode exists in a given parameter,...

i.e something liek.

Select * where partpostcode IS CONTAINED IN "PE10 1AF"

sadly there are no IS CONTAINED IN keywords, but i'm not sure how to do it using LIKE or IN...

Any comments ?

Thanks,
.