From: "Paul Groves" > 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
First try: SELECT 'My elbow' REGEXP '[[:<:]]elbow[[:>:]]'; and SELECT 'elbowed ligaments' REGEXP '[[:<:]]elbow[[:>:]]'; to see whether the regular expression are working correctly. I just ran a query similar to yours on a 4.0.23-standard server and it worked like a charm! Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
