List:General Discussion« Previous MessageNext Message »
From:Kristian Köhntopp Date:May 12 1999 1:06pm
Subject:Regular expression replacement on selected values
View as plain text  
I need to perform regular expression replacements on selected
values, i.e.

select replace(telefon, "[^0-9]", "") as telefon 
  from telefon_list;

Can this be done in Mysql or do I need to go procedural?


Kristian Köhntopp, NetUSE Kommunikationstechnologie GmbH
Siemenswall, D-24107 Kiel, Germany, +49 431 386 436 00
Using PHP3? See our web development library at (GPL)
Regular expression replacement on selected valuesKristian Köhntopp12 May