mysql index on derived table Possible Duplicate:
  Calculate MATCH() AGAINST() scores from UNIFIED QUERY not FOR EACH TABLE  




I want to have a FULLTEXT INDEX on data name in the base SELECT that selects data from another SELECT which unions several tables.

SELECT `data` FROM SELECT (
  SELECT `name` as `data` FROM `names`
  UNION SELECT `title` as `data` FROM `titles`
) as `search`


I want data to have a FULLTEXT INDEX
What is your requirement? we cannot index "data" as it is not a column in table, It can defined with multiple columns within one table . 

Few things to be considered while using Fulltext.
Its only supported for MyISAM engine,
You can also set few variables "ft_min_word_len" and "ft_max_word_len" to search,
Some stopwords are ignored we can set change values at "ft_stopword_file", and 
Its not case sensitive search.