I'd like to replace a specific string in OfflineLink with another string, say replacing "Other Media Sections/The Matrix" with "The Matrix Section". Neither string is the entire contents of the field in ANY record. (That field is unique to each record in the database, but much of it does overlap between large portions of records, and it's one of the portions that overlaps that I want to replace - about 700 records so far that need that replaced in.)
So I read up on the REPLACE function in SQL, and came up with the following SQL code:
Code: Select all
UPDATE "Fanfics" SET "OfflineLink" = REPLACE("OfflineLink", 'Other Media Sections/The Matrix', 'The Matrix Section')
Is there a way to replace this string within the field without needing it to be the entire contents of the field? I definitely don't want to have to manually edit 700 records! Did I use the wrong syntax? (It can be tricky adapting a command to Base's SQL requirements.) Did I miss an obvious guide online that would've solved my problem? Any assistance will be greatly welcomed.