title: mysql where clause on long strings makes the query too slow
body: <p>I have created a mysql table which has the crime count, Crime description, Crime Category and address of crime. I have created some reports over this table. The user wants to have a search by address filter in the report. so we are going to be using a where clause on table and have a condition over street.</p>
  
  <p>The problem is that street address is quite a large string and searching/filtering the table over address when the table is already quite big will take a lot of time. I tried using some hashing like md5(streetaddress) but that did not help either. The query become very slow with this kind of where clause</p>
  
  <p>example</p>
  
  <pre><code>select * from crimedata where streetaddress = "41 BENNETT RD Watertown  Massachusetts United States"
  </code></pre>
  
  <p>Will indexing the streetaddress help in this case  or should I use some kind of hashing to make this kind of string search faster in the table?</p>
  
  <p>Shah</p>