mysql FULLTEXT Searches

Are partial word searches available with a FULLTEXT index. I.E. could the following select statement return any results given that the word Pippins or Pippin's is indexed ? SELECT * from list WHERE MATCH (cols) AGAINST ('pipp') TIA, Pat... [EMAIL PROTECTED] MySql

Re: mysql FULLTEXT Searches

PROTECTED] Sent: Monday, July 22, 2002 10:35 AM Subject: mysql FULLTEXT Searches Are partial word searches available with a FULLTEXT index. I.E. could the following select statement return any results given that the word Pippins or Pippin's is indexed ? SELECT * from list WHERE MATCH (cols

Re: mysql FULLTEXT Searches

At 10:35 -0400 7/22/02, Patrick Sherrill wrote: Are partial word searches available with a FULLTEXT index. I.E. could the following select statement return any results given that the word Pippins or Pippin's is indexed ? SELECT * from list WHERE MATCH (cols) AGAINST ('pipp') Not as written.

Re: mysql FULLTEXT Searches

Thanks for the input, unfortunately are production server is still v 3.26.xx Pat... - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Patrick Sherrill [EMAIL PROTECTED]; mySQL List [EMAIL PROTECTED] Sent: Monday, July 22, 2002 2:40 PM Subject: Re: mysql FULLTEXT Searches