title: MySQL LIKE query with underscore
body: <p>I have the following table <code>images</code>:</p>
  
  <pre><code>+----+--------------+
  | id |   img_path   |
  +----+--------------+
  | 1  | abc_1.jpg    |
  | 2  | abc_2.jpg    |
  | 3  | abcde_1.jpg  |
  | 4  | abcde_2.jpg  |
  | 5  | abcdef_1.jpg |
  +----+--------------+
  </code></pre>
  
  <p>I would like to select the entries that <code>img_path</code> starts with <code>abc_</code>, so I use the following query:</p>
  
  <pre><code>SELECT id FROM images WHERE img_path LIKE 'abc_%'
  </code></pre>
  
  <p>But it returns all 5 rows. How do I only returns <code>id</code> = 1 &amp; 2 ( which <code>img_path</code> starts with <code>abc_</code>) ?</p>