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)