title: Optimization of MySQL search using "like" and wildcards
body: <p>How can queries like</p>
  
  <pre><code>SELECT * FROM sometable WHERE somefield LIKE '%value%'
  </code></pre>
  
  <p>be optimized?</p>
  
  <p>The main issue here is the first wildcard which prevents DBMS from using index.</p>
  
  <p>Edit: What is more, somefield value is solid string (not a piece of text) so fulltext search could not be performed.</p>