mostafalaravel
7 months ago

REGEXP_REPLACE in raw sql

Posted 7 months ago by mostafalaravel

Hello ,

I created a reg_exp to change the URL and keep the file name ,

you can see here : https://regex101.com/r/Exh39n/5

but in sql request it's not working ! :

select REGEXP_REPLACE(body,'http:.*?/(\w+\.\w{3,4})(?=\W+)','http://newsite.com/ $ 1') from DA_forum limit 450,1;

Please sign in or create an account to participate in this conversation.