Hi Rohit,
Sorry for the late reply.
I don’t think it will work as the the DB value is serialized and saved by PHP. Find and replace on it won’t work as the length of the value changes.
The best option would be to write a PHP code and execute it once.
You can try the script I wrote for now.
1) Take a backup of the shortcoder data first.
2) Paste the bwlow code in theme’s function.php file and refresh any wordpress page once.
function replace_sc_data(){
$scs = get_option( 'shortcoder_data' );
foreach($scs as $sc_name => $sc_prop){
$sc_content = $sc_prop['content'];
$replaced = str_replace('TO SEARCH TEXT', 'TO REPLACE TEXT', $sc_content);
$scs[$sc_name]['content'] = $replaced;
}
}
add_action('init', 'replace_sc_data');
3) Delete the code later and save the file.
Thanks,
Aakash
