Sign In/My Account | View Cart  

advertisement

AddThis Social Bookmark Button

Subject:   more appropriately ...
Date:   2003-11-08 10:42:06
From:   anonymous2
Response to: more appropriately ...

how to use regular expression to search


all digits of the pattern in MYSQL



X-XX-X
XX-XX-X
XXX-XX-X
XXXX-XX-X
XXXXX-XX-X



I tried



mysql> select * from database where field regexp "(\d{2,5}-\d{2}-d{1});


seems not working


regards
M.Karthikeyan
pl. mail:


karthik@email.unc.edu
Full Threads Oldest First

Showing messages 1 through 1 of 1.

  • more appropriately ...
    2004-01-12 08:36:19  anonymous2 [View]

    it works with
    mysql> select count(*) from database where field1 regexp "[[:digit:]]{2,6}-[[:digit:]]{2}-[[:digit:]]{1}";