MySQL Forums
Forum List  »  Full-Text Search

Is it possible to use full text search on a view?
Posted by: us97013
Date: May 11, 2006 01:17PM

Hi,

I have two tables. One is MyISAM and is as follows:

Items_Tags
{
Item_Id INTEGER,
Item_tags TEXT => Here I have created full-text search index
}

Another is InnoDB table and is as follows:
Items
{
Item_id INTEGER,
Item_name VARCHAR(255),
Item_data1 VARCHAR(255),
Item_data2 INTEGER
}

Now please tell me is it possible to create a view comprising of both the above tables (all of their above columns) and is it possible to apply full text search on the view to retrieve items?

What will be the possible sql definition for view? And how a full text will be applied to such a view (lets say V_Item)?

I cannot merge the two tables into one due to some reasons.

Thanks,

Arsalan

Options: ReplyQuote


Subject
Views
Written By
Posted
Is it possible to use full text search on a view?
4329
May 11, 2006 01:17PM


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.