Regular Expressions
Using Regular Expressions in MySQL Queries
Here is an example of how you would select data based on a regular expression. SELECT phone FROM table WHERE phone REGEX ‘^[0-9 ]{11,14}$’ = 0 LIMIT 100 The above would show all the phone numbers that are not between 11 and 14 numbers and spaces. SELECT phone FROM table WHERE phone REGEX ‘^[0-9 ]{11,14}$’ [...]
UK Postcode Regular Expression
Here is a UK postcode matching regular expression. I built it using a database of all the UK postcodes, so it does work for the strange ones. This regular expression will match the first part: ^[A-Z]{1,2}[0-9]{1,2}[A-Z]?$