title: Which is faster INSTR vs Like Prefix For varchar In MYSQL
body: <p>If my goal is to find out if there is a string in the column. The column has no unique btree index. Which is faster and more efficient: INSTR vs LIKE prefix for varchar in MYSQL, and why?</p>
  <p>Or are there other more-efficient methods?</p>
  <pre><code>INSTR(column, 'value') &gt; 0 
  </code></pre>
  <p>vs</p>
  <pre><code>column LIKE 'value%'
  </code></pre>
  <p>I looked up several questions, but there were only questions and answers about wild cards front and back.</p>
  <p>For example,</p>
  <pre><code>column LIKE '%value%'
  </code></pre>