At 8:04 -0700 10/5/04, Ed Lazor wrote:
Hi,
What's the best way to run a fulltext search when several fields from a
single table are involved?
You should have a FULLTEXT index for each combination of columns that
you want to use in the MATCH() part.
If you sometimes search Description, and other times search Description,
Title, and Summary, you need two FULLTEXT indexes.
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
I have a database of products with fields for Title, Summary, and
Description. The first two fields are varchar and the third is text. An
FULLTEXT index is created for the Description field.
Is it just an issue of adding the other two fields to the FULLTEXT index?
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
