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}';
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment