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 'c
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 M
