Sql statement removes irregular content

:HTTPS://HEALTH.123.COM/456.HTML
:HTTPS://NEWS.123.COM/789.HTML
:HTTPS://HEALTH.123.COM/147.HTML
....
 

SQL HEALTH456 

:MSSQL2014

:`update [newdata].[dbo].[Article] set Content=Replace(Upper(Cast(Content as nvarchar(max))),"","")`

Update sql

Mar.22,2021

The

problem is vague, so you can only give a directional suggestion to see if the database you are using supports regular expressions.
if it is oracle, you can use the regexp_replace function, for example:

SELECT regexp_replace('123 HTTPS://HEALTH.123.COM/456.HTML abc', 'HTTPS://(\w+)\.123\.COM/(\w+)\.HTML', '')
FROM dual;

Previous: Can the parameters passed by router-link be obtained in vue-router? How do I get the parameters if I can?

Next: How to easily update the docker deployment image without downtime

How to solve the problem that php sql update updates a large amount of data and fails to respond when it times out?
UPDATE `addon` SET `productsimages`= concat(productsimages, -sharp-sharp , BD-PT4878-1.jpg ),`jieshao`=concat(jieshao, -sharp-sharp , Immunohistochemical analysis of paraffin-embedded human-stomach-cancer tissue. 1,VIM PolBD-PClonal Antibody was d...

Big-data-handles concat update sql php

Apr.05,2021

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3644d-2c00b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3644d-2c00b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?