UPDATE IGNORE vn.entry e
JOIN vn.worker w ON w.code = TRIM(Right(REPLACE(e.notes, Char(10), ""), 4))
SET invoiceAmount = CAST(REPLACE(notes, ',', '.') as DECIMAL (10,2)),
buyerFk = w.id;