MySQL Forums
Forum List  »  Full-Text Search

Display fields from view with fulltext indices
Posted by: Colleen Boye
Date: May 08, 2013 01:26PM

I'm working on a search function for some views and I need a query that will list all the columns in the view with fulltext indices. I can query a table like so:

show index from treatments where index_type="fulltext";

But it doesn't work on views. Is there a query that will do the same thing, but for views?

Options: ReplyQuote

Written By
Display fields from view with fulltext indices
May 08, 2013 01:26PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.