title: Spark Data frame search column starting with a string
body: <p>I have a requirement to filter a data frame based on a condition that a column value should starts with a predefined string.</p>
  
  <p>I am trying following:</p>
  
  <pre><code> val domainConfigJSON = sqlContext.read
      .jdbc(url, "CONFIG", prop)
      .select("DID", "CONF", "KEY").filter("key like 'config.*'")
  </code></pre>
  
  <p>And getting exception:</p>
  
  <blockquote>
    <p>Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
    You have an error in your SQL syntax; check the manual that
    corresponds to your MariaDB server version for the right syntax to use
    near 'KEY = 'config.*'' at line 1</p>
  </blockquote>
  
  <pre><code>Using spark: 1.6.1
  </code></pre>