Case insensitivity in regular expressions

11/10/2007

Use the letter i after the ending delimiter. For example:

preg_match("/^TMG-[A-Z]-([0-9]+)/i",$itemNumber)
No Comments

Fetching MySQL rows that start with a number

27/10/2005

Use MySQL’s REGEXP support.

SELECT * FROM blah WHERE COLUMN REGEXP '^[0-9]+';
No Comments