RE: full text searching question

2003-06-04 Thread Andy Eastham
D] > Subject: full text searching question > > > can anybody explain this to me please! I search am searching > through a database > with first name and last names. BTW I use mysql 4.0.13 on RedHat > Linux 9.0 in > case that matters. I created a fulltext search on both fiel

RE: full text searching question

2003-06-04 Thread Andy Eastham
core DESC; The db engine won't execute the full text query more than once so this is not inefficient. Andy > -Original Message- > From: Chris Wilkinson [mailto:[EMAIL PROTECTED] > Sent: 03 June 2003 13:12 > To: [EMAIL PROTECTED] > Subject: full text searching questio

Re: full text searching question

2003-06-04 Thread Paul DuBois
At 13:11 +0100 6/3/03, Chris Wilkinson wrote: can anybody explain this to me please! I search am searching through a database with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in case that matters. I created a fulltext search on both fields together so I can search the

Re: full text searching question

2003-06-04 Thread kjc
User ORDER BY First Name Chris Wilkinson wrote: can anybody explain this to me please! I search am searching through a database with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in case that matters. I created a fulltext search on both fields together so I can search t

full text searching question

2003-06-04 Thread Chris Wilkinson
can anybody explain this to me please! I search am searching through a database with first name and last names. BTW I use mysql 4.0.13 on RedHat Linux 9.0 in case that matters. I created a fulltext search on both fields together so I can search them like this: mysql> SELECT first_name,last_name