Archive for May, 2009
Force Users to use www.yourdomain.com not yourdomain.com.
If your having problems with cookies, and incoming links sometimes varying between www.example.com and example.com, which doesn’t help SEO. Use this quick fix to solve your problem.
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]?$