From: Peter Brawley
Date: February 18 2005 5:44pm
Subject: Re: select columns in full text index
List-Archive: http://lists.mysql.com/mysql/180188
Message-Id: <4216296C.2070104@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Brian,

 >I'd like to be able to query the db to find which columns are indexed
 >depending on the table to be searched so i can then create my MATCH().
 >I'm having a heck of a time googling for this.

Until MySQL implements a proper data dict, you'll have to parse the 
output from SHOW INDEX, where 'column_name' shows the col(s) and 
'index_type' says FULLTEXT if it is.

PB

-----

brian ally wrote:

> I have several tables which have some columns indexed for full text 
> searching.
>
> table 1:
> FULLTEXT(foo,bar)
>
> table 2
> FULLTEXT(pip,pop,pup)
>
> table 2:
> FULLTEXT(hip,hop)
>
> I'd like to be able to query the db to find which columns are indexed 
> depending on the table to be searched so i can then create my MATCH(). 
> I'm having a heck of a time googling for this.
>
> Hope that's clear enough,
> brian
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 2/14/2005