title: How to fasten execution for table having 100 million record for like query
body: <p>i am working on a project where we have 100 millions record in a table. on that table we perform different queries but like query for title is taking too much time. at the time table is in innoDB. We are using aws rds. AWS RDS is not allowing us to convert innoDB to MyISAM. what could be the solution for fasten execution time for like queries if we use innoDb.</p>
  
  <p>Query is exactly like this</p>
  
  <pre><code>select table_id from table where title like '%keyword%' limit 10000000,20
  </code></pre>
  
  <p>main problem comes when use 'like' with higher limit offset. 
  let suppose we are getting rows which are found at the last of table than query is taking too much time for skipping first millions record while performing limit with higher offset.</p>