title: the best way to use LIKE query in websql.
body: <p>I have a 2 tables that are old_test and new_test /bible database/<br></p>
  
  <pre><code>old_test table has 7959 rows
  
  new_test table has 23145 rows
  </code></pre>
  
  <p>I want to use LIKE query to search verse from two tables. </p>
  
  <p>For example: </p>
  
  <pre><code>SELECT * 
    FROM old_test 
   where text like "%'+searchword+'%" 
  union all 
  SELECT * 
    FROM new_test 
   where text like "%'+searchword+'%"
  </code></pre>
  
  <p>It works good but taking a lot of time to show the result.</p>
  
  <p>What is the best solution to search much faster on above condition?</p>
  
  <p>Thanks</p>