MYSQL fulltext - What's the right way to get the relevance from one column?
MyISAM? or InnoDB?

4 FULLTEXT indexes will work in either engine.

You could find out by creating an empty table and running that SELECT against it.  It should give you an error if the set of indexes you tried is wrong.  The ALTER to add/drop indexes.