By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (Id INT, Note TEXT, Client VARCHAR(128))
SELECT 1 Id, 'Long note that have
multiple lines
Client: Name-1' Note, NULL Client
UNION ALL
SELECT 2, 'Anoter note that have multiple lines
Customer: Name-2', NULL
UNION ALL
SELECT 3, 'Third note that have multiple lines
Client : Name-3', NULL;
SELECT * FROM test;
Records: 3 Duplicates: 0 Warnings: 0
| Id | Note | Client |
|---|---|---|
| 1 | Long note that have multiple lines Client: Name-1 |
null |
| 2 | Anoter note that have multiple lines Customer: Name-2 |
null |
| 3 | Third note that have multiple lines Client : Name-3 |
null |
UPDATE test
SET Client = SUBSTRING_INDEX(Note, ': ', -1);
SELECT * FROM test;
Rows matched: 3 Changed: 3 Warnings: 0
| Id | Note | Client |
|---|---|---|
| 1 | Long note that have multiple lines Client: Name-1 |
Name-1 |
| 2 | Anoter note that have multiple lines Customer: Name-2 |
Name-2 |
| 3 | Third note that have multiple lines Client : Name-3 |
Name-3 |