mysql searching with fulltext indexing
| From: | Bevan Christians | Date: | Wed, 24 May 2006 08:23:13 +0000 |
| Subject: | mysql searching with fulltext indexing | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-41927@lists.php.net to get a copy of this message | ||
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)