REGEXP wrong behavour

Hi, all

Can someone expalin me why this statement gives a wrong result:
SELECT "a a(word)a a" REGEXP "[[:<:]]a(word)a[[:>:]]"; results 0.
But I expect this results TRUE because of setting of null boundary
correspondings at the beginning and the ending of the word ("a(word)a") in
REGEXP.

Thanks,
AZtpa,







--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org