title: Case insensitive Regex in Python
body: <p>I have following Python regex:</p>
  
  <pre><code>re =re.match(r'.*? from\s+(.*?)(\s.*|$)', q)
  </code></pre>
  
  <p>Here, q is a query like this:</p>
  
  <pre><code>Q1 = u"select * from dlpx_jobs where job_id=\\'531\\';"
  
  Q2 = u"select * FROM dlpx_jobs where job_id=\\'531\\';"
  </code></pre>
  
  <p>Now, obviously, for Q1 the regex works because "from" is lowercase in the query but for Q2 regex doesn't work because in Q2 "from" is in Uppercase. </p>
  
  <p>Is there any way through which the regex works for both the query irrespective of whether "from" is uppercase or lowercase?</p>