Hi Listies

I have a question

Is there any to query a mysql table to get it to return the field
names that it currently
has marked as Fulltext Indexes?

I need to build a searching engine, there are 60 tables being
searched, i have created the fulltext indexes on all tables required
and i currently have the tables in an array
now what i want to do is use a for loop to loop through each table
find its releveant FTS Indexes and then based on the field name use it
in a MATCH() AGAINST() query and then return all the results in xml?

Anyone have any idea how i can query the tables in order to get it to
return the indexes

Thanks in advance (hoping you guys can help)

Reply via email to