By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE wl_content (message TEXT);
INSERT INTO wl_content VALUES
('i.e. I want to replace "Kind Regards blah_links blah_link blah_links'),
('Kind Regards Linkedin Facebook Google Image link Some Random Text');
SELECT * FROM wl_content;
| message |
|---|
| i.e. I want to replace "Kind Regards blah_links blah_link blah_links |
| Kind Regards Linkedin Facebook Google Image link Some Random Text |
UPDATE wl_content
SET message = CONCAT(SUBSTRING_INDEX(message,
'Kind Regards',
1),
'Kind Regards R');
SELECT * FROM wl_content;
| message |
|---|
| i.e. I want to replace "Kind Regards R |
| Kind Regards R |