title: Same query on phpmyadmin and vb.net get different results
body: <p>I'm getting different query results from using phpmyadmin directly and on vb.net.</p>
  
  <p>I used this query <code>SELECT * FROM tbllocation WHERE loc_name LIKE '%ROOM%'</code></p>
  
  <p>Here's the phpmyadmin and database server version:</p>
  
  <p><img src="https://i.stack.imgur.com/qorLR.png" alt="Here&#39;s the phpmyadmin and database server version."></p>
  
  <p>Here are the results from phpmyadmin:</p>
  
  <p><img src="https://i.stack.imgur.com/FSiGD.png" alt="Here are the results from phpmyadmin"></p>
  
  <p>Results from vb.net:</p>
  
  <p><img src="https://i.stack.imgur.com/fXOfs.png" alt="Results from vb.net"></p>
  
  <p>Here's my code in vb.net for getting and showing the query results.</p>
  
  <pre><code> cmd.CommandText = q
      dr = cmd.ExecuteReader
      Dim rowindex As Integer = 0
      If dr.Read Then
          While dr.Read
              MsgBox(dr(1))
              DataGridView1.Rows.Add(dr(1), dr(2), "", "")
              DataGridView1.Rows(rowindex).Tag = dr(0)
              rowindex += 1
          End While
      End If
      dr.Close()
  </code></pre>