Women in Technology

Hear us Roar

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

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

Partner Sites