: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))),"","")`
: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))),"","")`
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;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...