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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
