title: Regular Expression for zipcode pattern?
body: <p>How to write regular expression  for zipcode pattern? I need to makesure that all zipcodes(sample addresses) are 5 digits, but my query is not working. </p>
  
  <pre><code>with table1 as(
  select "123 6th St. Melbourne, FL 32904" as address union all
  select "71 Pilgrim Avenue, Chevy Chase, MD 20815"  union all
  select "70 Bowman St. South Windsor, CT 06074" union all
  select "4 Goldfield Rd. Honolulu, HI 966815"  union all
  select "44 Shirley Ave. West Chicago, IL 60185" union all
  select "514 S. Magnolia St. Orlando, FL 32806 "
  )
  select address,regexp_contains("address",r"\s\d{5}$")check from table1
  </code></pre>