title: REGEX in mysql query
body: <p>i have a table with <code>address</code> as column.</p>
  
  <p>values for address is <code>"#12-3/98 avenue street"</code>, which has numbers, special characters and alphabets.</p>
  
  <p>i want to write my sql query usng <code>regex</code> to <em>remove special characters</em> from the address value</p>
  
  <p>ex: "<code>12398avenuestreet</code>" will be the value i want after removing the special characters</p>
  
  <p>thank you.</p>