Re: FULLTEXT index on two tables and many columns

2003-02-27 Thread Grzegorz Paszka
On Thu, Feb 27, 2003 at 09:27:41AM -0500, Brent Baisley wrote: > Maybe you should rethink your whole database structure. In your > simplified example, you really only have two pieces of data, the text > and a qualifier (a, b, c, d, e, ...). So instead of separating your > "text" into different c

Re: FULLTEXT index on two tables and many columns

2003-02-27 Thread Brent Baisley
Maybe you should rethink your whole database structure. In your simplified example, you really only have two pieces of data, the text and a qualifier (a, b, c, d, e, ...). So instead of separating your "text" into different columns, keep all your text in one column and add another column that a

FULLTEXT index on two tables and many columns

2003-02-26 Thread Grzegorz Paszka
Hi. I know that for fulltext index are some limitations as: All parameters to the MATCH() function must be columns from the same table that is part of the same FULLTEXT index, unless the MATCH() is IN BOOLEAN MODE. But "A boolean full-text search can also work even without a FULLTEXT index, alth