I have a database named "DB1" which has many tables .
Our database is crashed miserably and all the column values from almost all tables have changed (hacked)... example below.
If the original column has values like below:
New york, etc...
Some sql injection happened and the column values are added with some weird string "www.abcd.com
So, my column values become like this now:
if you notice, for some cities the hacker string is added 2 times, and for some 3 times etc...
Now I want a stored procedure / script that will remove / truncate all these added values.. Since the string that is added is same through out the table irrespective of no of iteration, I guess the cleansing canbe done through some sql script..
I want the script will search whole database and and delete the hackers string.
Appreciate your help.