ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.

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


1 to 1 of 1
1 to 1 of 1