SQL Server How can I replace a URL prefix using SQL?

yizd12fk 于 2023-08-02 发布在其他

关注(0)|答案(1)|浏览(109)

In my SQL database, I have a SQL table where there is a column that stored the URL of some images that I am displaying on my website. The URL field is something like http://some_domain/some_thing

I need to replace all of them with something like https://some_domain/some_thing

I can write a C# script to do the same and write the required regex in C#. Does anyone know how to do this kind of replacement in SQL Server.

sql-server

来源：https://stackoverflow.com/questions/42064582/how-can-i-replace-a-url-prefix-using-sql

1条答案

按热度按时间

lx0bsm1f1#

You need to search for all entries that have an http:// prefix and then replace it, eg:

UPDATE MyTable
set ImageUrl=REPLACE(ImageUrl,'http://','https://')
where ImageUrl like 'http://%'

The WHERE clause ensures that only entries with http:// are processed and allows the query to take advantage of possible indexes on the image field. LIKE 'abc%' is essentially a range search that matches values between abc and the next entry after the prefix, ie abd`

赞(0）回复(0）举报 2023-08-02

我来回答

SQL Server How can I replace a URL prefix using SQL?

1条答案

相关问题

热门标签

最新问答