Linux DB PHP Scripts Tech Diary
Search This Blog
Sunday, January 23, 2011
mysql regular express
Tel phone number 555-555-5555
SELECT * FROM phone WHERE pnumber REGEXP '[0-9]{3}-[0-9]{3}-[0-9]{4}';
CAS number
SELECT * FROM products WHERE cas REGEXP '[0-9]{2,7}-[0-9]{1,2}-[0-9]{1}';
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)