Re: REGEXP word boundary problem

2005-03-24 Thread Paul Groves
Jigal van Hemert wrote: From: "Paul Groves" BTW is there anyway to speed up the search, as I think this may be pretty slow (there will be about 25000 records in the real database...) e.g. maybe by doing a LIKE match for "%elbow%" first then doing a REGEXP within that? Not sur

Re: REGEXP word boundary problem

2005-03-24 Thread Paul Groves
Paul Groves wrote: 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 elb

Re: REGEXP word boundary problem

2005-03-24 Thread Paul Groves
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 Who

REGEXP word boundary problem

2005-03-24 Thread 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

MySQL on Mac OS X?

2001-09-12 Thread Paul Groves
Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, regards Paul --

MySQL on Mac OS X?

2001-09-12 Thread Paul Groves
Has anyone had any experience of running MySQL on Mac OS X? If so, how have you found it - is it stable and non-buggy? Also, has anyone had any experience of using both MySQL *and* PHP together on Mac OS X? I would be very interested to hear anyone's thoughts on this, regards Paul

Re: Access and MySQL

2001-08-31 Thread Paul Groves
/ - Original Message - From: "Stephen Johnson" <[EMAIL PROTECTED]> To: "MySQL" <[EMAIL PROTECTED]> Sent: Friday, August 31, 2001 4:29 PM Subject: Access and MySQL > I have a client that uses an Access dB in house and wants that database to > automatically update a MySQL database that I

Re: just starting problem - WinNT

2001-08-31 Thread Paul Groves
- Original Message - From: "Neil Davies" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, August 31, 2001 12:11 PM Subject: just starting problem - WinNT > I am using, well trying to use mysql through WinNT. I have > successfully installed mysql and have had a look at the client