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
