Search code examples
mysqlfull-text-searchinformation-schema

how can i find all column with full text index in mysql 4.1.22

I'm trying to find all column of a mysql database (4.1.22) whith a Full Text index.

With Mysql > 5.0 i can run this query 

SELECT TABLE_SCHEMA, TABLE_NAME
FROM information_schema.STATISTICS
WHERE index_type LIKE 'FULLTEXT%'

but information_schema is not supported in mysql 4.1.22, so i don't know anything else

Suggestions ?

Thanks

Solution

  • As documented under SHOW INDEX Syntax:

    SHOW INDEX returns the following fields:

    [ deletia ]

    • Index_type

      The index method used (BTREE, FULLTEXT, HASH, RTREE).

    • Comment

      Various remarks. Before MySQL 4.0.2 when the Index_type column was added, Comment indicates whether an index is FULLTEXT.

    You can then parse the results to determine over which columns FULLTEXT indexes have been defined.