title: Full text search with InnoDB tables
body: <p>I need to use full text search but the tables that I am using in my web application use the INNODB engine, from what I read JDBC does not have support for Mysql triggers and I am supposed to deploy the project on the course server so installing tools such as sphinxs is not possible, could someone please suggest a method to perform a full-text search?</p>
  
  <p>thanks</p>
  
  <p>Edit: the requirement in the project is to have a consistent database, the table on which I want to perform search contains the list of instruments that exist in the lab for which I am building the web application, it is possible to insert new instruments to it, but let's assume that the insert accesses are few and that mostly the table will be used for read access, in this case, is using MyIsam justifiable and would it conform with the consistency requirements (Myisam doesn't support transactions)?</p>