Postcode Regexp

[DannyTmoov2]

I'm trying to get the following to return false:
SELECT TRIM(' EX7 5AW') REGEXP "^E|EC|EN|N|NW|SE|SW|W|WC[1-9][0-9]? ";

Which basically should return true for london postcodes. I.E. if the first part (the textual chars) is in E|EC|EN|N|NW|SE|SW|W|WC and the second part (the numbers) is either one or two numerical values between 1 and 9.

The above returns true when it shouldn't because EX isn't in the list. Any help much apprecaited

 

[piti]

i think putting the char part in brackets, either () or [], should do the job
^[E|EC|EN|N|NW|SE|SW|W|WC][1-9][0-9]?

 

[DannyTmoov2]

Thanks the () did it!