title: using wildcard in Spark SQL
body: <p>I have a dataframe like this:</p>
  
  <pre><code>+-------------------------------------------+
  |url                                        |
  +-------------------------------------------+
  |/v3/references/genders                     |
  |/en/job/restaurant-manager-6619735/panels  |
  |/en/job-search/dealer-coordinator-jobs/    |
  |/en/job/engineer-3034030/panels            |
  |/en/job/business-analyst-5385899           |
  +-------------------------------------------+
  </code></pre>
  
  <p>I'm trying to get the count for each url that contains 'job'. I tried this but I got empty result.</p>
  
  <pre><code>df.createOrReplaceTempView("table")
  spark.sql("select url, count(url) from table where url like 'job'").show()
  </code></pre>
  
  <p>What is wrong with that sql?
  Thanks!</p>