I have a full text index of a MYSQL myisam table. I am writing a full text search, and I would like to be able to output the contents of this full text index using PHP.
The search input uses javascript to help users complete their search term input and so as I the search is running this index, it would be the best option to generate the text completion list from this record. Does anyone know the sql command I would need to run to access this information?