About Updating SQL Data

[willxam]

Hello, I have a table named "testlink" containing columns "url" and "newtarget." I want to extract the string expressions from the URL column, which is https://domain1.com/[the string here], and replace all the data in the "newtarget" column with https://domain1.com/search/?q=the extracted string expression. In short, URLs in the format https://domain1.com/topic1 from the URL column will be replaced with https://domain1.net/search/?q=topic1 in the newtarget column. There are approximately 6,000 different topics (rows) in the table. I tried to do this using the Find & Replace method, but due to my limited knowledge, I couldn't accomplish it. I would appreciate any assistance in this matter.