title: INDEX or FULLTEXT to store a VARCHAR(1000) in MySql
body: <p><strong>My purpose</strong>:<br> 
  I need to make <code>SELECT WHERE string IN ('...')</code> queries, and <code>string</code> is a <code>VARCHAR (1000)</code></p>
  
  <p><strong>The question:</strong><br>
  I do not know if I should use a <em>FULLTEXT</em> index for it or just a simple <em>INDEX</em></p>
  
  <p><strong>The problem:</strong><br>
  The search will be done making a multiple <code>UNION</code> in the query with two similar tables, which contain both the <code>string</code> field, so I don't neither know if the <em>FULLTEXT</em> will make this faster or not.<br>
  <em>(My idea of FULLTEXT indexes is using them with MATCH AGINST queries)</em></p>
  
  <p><strong>The structure:</strong><br>
  You can see how I structured my multiple <code>string</code> fields in the different tables in a question I did before at <a href="https://stackoverflow.com/questions/15177338/how-to-structure-this-database-idea-to-make-it-the-fastest-and-cleanest-as-possi">How to structure this DATABASE idea</a></p>
  
  <p><strong>Note:</strong><br>
  This question is about which type of INDEX is better for the case. I just linked the structuring question to give readers more references on what I am doing. It is not a duplicated.</p>