Re: [PHP-DB] mysql searching with fulltext indexing

2006-05-24 Thread Bevan Christians
thanks muchly for the help guys :D On 24/05/06, Chris <[EMAIL PROTECTED]> wrote: > Anyone have any idea how i can query the tables in order to get it to > return the indexes show indexes from tablename; http://dev.mysql.com/doc/refman/5.0/en/show-index.html -- Postgresql & php tutorials http:

Re: [PHP-DB] mysql searching with fulltext indexing

2006-05-24 Thread Chris
Anyone have any idea how i can query the tables in order to get it to return the indexes show indexes from tablename; http://dev.mysql.com/doc/refman/5.0/en/show-index.html -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubsc

Re: [PHP-DB] mysql searching with fulltext indexing

2006-05-24 Thread Stut
Bevan Christians wrote: Is there any to query a mysql table to get it to return the field names that it currently has marked as Fulltext Indexes? |SHOW COLUMNS FROM sometable -Stut | -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql searching with fulltext indexing

2006-05-24 Thread Bevan Christians
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 current