e Rapaport [mailto:[EMAIL PROTECTED]]
> Sent: 03 January 2002 04:39
> To: Neil Tompkins
> Cc: [EMAIL PROTECTED]
> Subject: Re: Full Search
>
>
> Yes, you can add a FULLTEXT index to that table including all 15 fields,
> e.g.
> CREATE FULLTEXT INDEX findtext ON mytabl
nen
[EMAIL PROTECTED]
-Original Message-
From: Steve Rapaport [mailto:[EMAIL PROTECTED]]
Sent: 03 January 2002 04:39
To: Neil Tompkins
Cc: [EMAIL PROTECTED]
Subject: Re: Full Search
Yes, you can add a FULLTEXT index to that table including all 15 fields,
e.g.
CREATE FULLTEXT INDEX findtext
Yes, you can add a FULLTEXT index to that table including all 15 fields, e.g.
CREATE FULLTEXT INDEX findtext ON mytable (field1, field2, field3,...field15);
Caveats:
The fields must be of type VARCHAR or TEXT to work, (CHAR can be changed to
VARCHAR easily, and often is silently changed.)
Depend
