arkinEx Codex

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.
continue reading »

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}$' LIMIT 100

The above would show all the phone numbers that are between 11 and 14 numbers and spaces.

I hope this quick guide has helped.
Any questions, feel free to ask.

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]?$

continue reading »