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.
Yes, these both work fine... which makes me think there is something wrong with my syntax for my query, but I don't know what...
I just ran a query similar to yours on a 4.0.23-standard server and it worked like a charm!
I'm running 4.1.10a if it makes any difference
regards
Paul
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
