Let us assume that there is a table:
In this table there are two columns:
1 2 ID, DESCRIPTION
By mistake someone captured client sensitive information as part of description which needs to be replaced with xxxx.
- SQL update query to do that is:
1 2 3 UPDATE CLIENT_COMPLAINTS SET DESCRIPTION = REPLACE(DESCRIPTION, '01/2021', 'xx/xxxx') WHERE id=2154485618838;