Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Jon Cooper
June 24, 2005, 8:32 pm
rate this thread
I know very little about regex so this is bound to be simple...
I need to scan thru a db and check postcodes are in the format AB1 123, AB10
123 or A12 123.
Now I know I need to use regex but am struggling with the syntax...
I thought postcode REGEXP '([a-z][a-z][0-9][0-9] [0-9][a-z][a-z])' might do
it for the second
pattern(letter,letter,number,number,space,number,letter,letter) but all this
seems to do is ignore the sequence and just says 'does this include numbers
and letters and spaces?' Yep? ok then its a pass even when the pattern is
not what I want.
- » Query help: Get category and number of items in one query
- — Next thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum