atleast: d-dd-d
0-00-0
9-99-0
select count(*) from processes where
`in` regexp "[0-9]{1}-[0-9]{2}-[0-9]{1
}";
for:
00-00-0
99-99-0
select count(*) from processes where
`in` regexp "[[:space:]][0-9]{2}-[0-9]
{2}-[0-9]{1}";
for
00-00-0,
99-99-0,
select count(*) from processes where
`in` regexp "[[:space:]][0-9]{2}-[0-9]
{2}-[0-9]{1}[[:punct:]]";
for
000000-00-0,
999999-99-0,
select count(*) from processes where
`in` regexp "[[:space:]][0-9]{6}-[0-9]
{2}-[0-9]{1}[[:punct:]]";
temporarily solved.. but not the perfect way... I belive..
Experts help required for single query..
karthikeyan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
