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}';


at

1 comment:

  1. Tech NotesOctober 3, 2011 at 1:48 PM

    search non-ascii chars:

    vim
    /[\x7f-\xff]
    or
    /[^[:print:]]

    SQL:
    select signatureID, name, signature from signatures where signature REGEXP '[\x80-\xff][1,2000]' ;

    select signatureID, name, signature from signatures where signature REGEXP '[^[:print:]]' ;

    ReplyDelete

Subscribe to: Post Comments (Atom)