List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:February 18 2005 5:44pm
Subject:Re: select columns in full text index
View as plain text  
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

Thread
select columns in full text indexbrian ally18 Feb
  • Re: select columns in full text indexPeter Brawley18 Feb