I have one query:
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}d{1})";
others:
*-*-*
??-??-?
???-??-?
(\d{2,5})?- etc, seems not working
I searched and read the mysql doc (link sent by you) earlier, but could
not get answer for this particular problem
it is more or like searching phone number pattern, but not working.. I
tried almost 20 such combinations
because '-' is understood as "from" - "to" e.g a-z, 0-9, etc.,
can you help
regards
m.karthikeyan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
