title: MySQL starts with searching issue
body: <p>I'm having an issue using the <code>%</code> wildcard with a MySQL query.</p>
  
  <p><a href="http://www.w3schools.com/sql/sql_like.asp" rel="noreferrer">http://www.w3schools.com/sql/sql_like.asp</a></p>
  
  <p>Having read that article, I am using <code>%</code> and not getting quite what I was expecting.</p>
  
  <p>I have a  series of values, such as</p>
  
  <pre><code>1_1
  1_2
  2_1
  2_2... etc
  </code></pre>
  
  <p>including</p>
  
  <pre><code>11_1
  11_2
  </code></pre>
  
  <p>Now, in some cases I want to return specifically those whose value = <code>11_2</code>, or <code>1_2</code> etc. This works fine</p>
  
  <pre><code>WHERE fieldName = '11_2'
  </code></pre>
  
  <p>etc... as expected</p>
  
  <p>However, in some cases I want to find all items which start with a <code>1</code> or all items which start with <code>11</code></p>
  
  <p>From the w3Schools link, I was expecting </p>
  
  <pre><code>WHERE fieldName LIKE '1_%'
  </code></pre>
  
  <p>To find anything that begins with <code>1_</code> specifically, therefore, in my example, returning:</p>
  
  <pre><code>1_1
  1_2
  </code></pre>
  
  <p>BUT, it also returns</p>
  
  <pre><code>11_1
  11_2
  </code></pre>
  
  <p>Why is this? And how can I over come it?</p>