1 message in com.mysql.lists.mysqlKeyword Searching using FULLTEXT
FromSent OnAttachments
Brett Lytle15 Nov 2001 10:55 
Subject:Keyword Searching using FULLTEXT
From:Brett Lytle (bre@lytleworks.com)
Date:11/15/2001 10:55:11 AM
List:com.mysql.lists.mysql

Hi, I have a mysql table I am searching using the FULLTEXT INDEX feature. However, the legacy database that I am working from had 90 different fields holding a keyword in each of them. Since the FULLTEXT INDEX only holds 15 different fields, I would much rather have the fields concatenated into one or two larger text fields. Is there any reason not to do this performance wise? -Brett