title: Spark SQL - rlike ignore case
body: <p>I am using spark SQL and trying to compare a string using <code>rlike</code> it works fine, however would like to understand how to ignore case. </p>
  
  <p><strong>this return true</strong> </p>
  
  <pre><code>select "1 Week Ending Jan 14, 2018" rlike "^\\d+ Week Ending [a-z, A-Z]{3} \\d{2}, \\d{4}"
  </code></pre>
  
  <p><strong>However, this return False,</strong></p>
  
  <pre><code>select "1 Week Ending Jan 14, 2018" rlike "^\\d+ week ending [a-z, A-Z]{3} \\d{2}, \\d{4}"
  </code></pre>