title: Show a tables FULLTEXT indexed columns
body: <p>I'm looking to run a query that will return a list of columns in a table that are FULLTEXT indexed. The table is in MyISAM format and i'll be using php to construct the query.</p>
  
  <p>Ideally i would run the query and it would return the information so i could construct a comma separated string of the columns. </p>
  
  <p>e.g. "first_name, last_name, email"</p>
  
  <p>Is this possible in MySQL?</p>