REGEXP word boundary problem

[Paul Groves]

I'm having a problem with REGEXP and word boundaries, my query does not 
throw an errow, but isn't giving me any results e.g. my query is:

SELECT * FROM object WHERE description REGEXP '[[:<:]]elbow[[:>:]]';
There are records in the object table that have the following 
description fields (as test data):

elbows ligaments
elbowed ligaments
My elbow
elbow joint
Whose elbow is that
The query should, as far as I can tell from 
http://dev.mysql.com/doc/mysql/en/regexp.html, be returning the last 
three records, but is returning nothing... any ideas? Thanks

Paul
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]