Hi, I could get the expected result in version 4.1.10a-log with that former single query , which failed in your environment. May be some configure options missing? Which configure options is your Mysql built with ? !!
Regards Usha ----- Original Message ----- From: "Paul Groves" <[EMAIL PROTECTED]> To: "Jigal van Hemert" <[EMAIL PROTECTED]> Cc: "Paul Groves" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com> Sent: Thursday, March 24, 2005 5:47 PM Subject: Re: REGEXP word boundary problem > Jigal van Hemert wrote: > > 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] > > > > -- > No virus found in this incoming message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 3/23/2005 > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
