title: using regular expressions in redshift
body: <p>This query works in mysql but I am not sure how to write the same query in redshift / postgresql.</p>
  
  <pre><code>update customer_Details set
  customer_No = NULL
  WHERE customer_No NOT REGEXP '^[[:digit:]]{12}$' 
  </code></pre>