```postgresql
BEGIN;
CREATE TEMP TABLE target_notes AS
SELECT id
FROM note
WHERE
(COALESCE(text, '') ILIKE '%まりはち%'
OR COALESCE(cw, '') ILIKE '%まりはち%')
AND deleted_at IS NULL;
UPDATE note
SET
text = NULL,
cw = NULL,
file_ids = '{}',
deleted_at = NOW()
FROM target_notes t
WHERE note.id = t.id;
COMMIT;
```
