How to search and replace a value in the database?

[Kaye_McClendon]

Thousands of students are assigned to an specific admissions counselor. However, that counselor has left and we know how to reassign all of those students to a new counselor. What's the easiest way to search and replace a value in the Marketo database?

[Darshil_Shah1 · Accepted solution]

If you are referring to searching and changing the field value in marketo then you can create a Batch Campaign with smart list filter as "<field name>" is "Old Value" and set the flow step as Change Data Value <field name> and set as <new value>.

Ref. for Change Data Value Flow step. I believe this is the best approach.