I have a database with name
test having two tables
I need a replace function or procedure that does the following
- Find columns with String data type (Text,varchar,char,etc) in all tables within
- Look for a value in that column and replace it with a new value
I have found an stored procedure in this post but I don't understand how it works.
is there anyway to achieve this or adopt the stored procedure in the linked post for my use?