SQL Replace mit Regex (Mysql-Regexp)

Submitted by Gast (nicht überprüft) on Di, 01/15/2019 - 20:40

Mysql Query - Update mit Regex

update mytable1 

set myfield1=regexp_replace(
myfield1, 
'<div class="oldsite">(.*)</div>', 
'<div class="newsite"> <p> \\1 </p> </div>'
)

 

Neuen Kommentar schreiben

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.