Case insensitivity in regular expressions

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

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

Fetching MySQL rows that start with a number

Use MySQL’s REGEXP support.

SELECT * FROM blah WHERE column REGEXP '^[0-9]+';