title: How to Index on a blob column mysql
body: <p>I have a table which have three columns id, copyId, and referral</p>
  <blockquote>
  <p>id is primary key and int(11)</p>
  <p>copyId is varchar (255)</p>
  <p>referral is medium blob</p>
  </blockquote>
  <p>In referral column i am saving links in josn array</p>
  <p>like this</p>
  <pre><code>array('http://example1.com/id','http://example2.com/id','http://example3.com/id','http://example4.com/id');
  </code></pre>
  <p>convert above array in json_encode and save into referral column</p>
  <p>my all queries search id in referral column links and i have tons of load in database i think my this table take much loads this table have approx <strong>160,000</strong> records and each blob have <strong>500 above links</strong> when i have do research i found that index is very good for retrieving data.</p>
  <p>I want your help to indexing blob and give me suggestions what should i do for improving preformance of this table and i am using phpmyadmin for indexing please don't tell me query tell me what index should i apply on referral column.</p>
  <p><strong>1) index
  2) fulltext
  3) primary
  4) spatial
  5) unique</strong></p>
  <p>and i have not any use of id column which is primary key i think i should delete this column is it a good idea for better performance.</p>
  <p>And please suggest me what should i do for mysql better performance
  Thank you</p>