title: How to get row in sql by only a 1 char of one of the fields
body: <p>I have field <code>strcont Varchar (40)</code> in MySQL database and <code>char c</code>. So I need all rows where <code>strcont</code> starts with <code>c</code></p>
  
  <p>For example:</p>
  
  <pre><code>Table - tbl. Columns - id, strcont, sthOther.
  strcont = {"abcd", "adcs", "bdcs", "bjfh"}
  </code></pre>
  
  <p>and <code>c = 'a'</code>. 
  So it returns only <code>"abcd"</code> and <code>"adcs"</code></p>