title: Slow search by index query LIKE% MYSQL
body: <p>i have table with 100 000 000 rows so large.
  Structure of table</p>
  
  <pre><code>id         int          INDEX(not primary not unique just index)
  lang_index varchar(5)   INDEX
  name       varchar(255) INDEX
  enam       varchar(255) INDEX
  </code></pre>
  
  <p>Ok. i do query </p>
  
  <p>1 Query</p>
  
  <pre><code>"SELECT name FROM table WHERE lang_index='en' AND name LIKE 'myname%'"
  </code></pre>
  
  <p>Speed is ok for this large table. around 0.02 sec.</p>
  
  <p>i try 
  2 Query</p>
  
  <pre><code>"SELECT name FROM table WHERE lang_index='en' AND (name LIKE 'myname%' OR enam LIKE 'myname%')"
  </code></pre>
  
  <p>Very very slow around 230 sec!!!</p>
  
  <p>then i try this 
  3 Query</p>
  
  <pre><code>"SELECT name FROM table WHERE lang_index='en' AND enam LIKE 'myname%'"
  </code></pre>
  
  <p>Speed is fantastic. around 0.02 sec.</p>
  
  <p>Then i explode my 2nd query for two queries (1 and 3 query) its faster. around 0.04 sec but it not simply.</p>
  
  <p>Why my query is slow? Two queries much faster than one. 
  I need do this <code>"SELECT name FROM table WHERE lang_index='en' AND (name LIKE 'myname%' OR enam LIKE 'myname%')"</code>
  How i can make it faster?</p>