[HELP] Find and Replace Wordpress phpMyadmin wp_postmeta, meta_value, repeatable_fields

momowriter

Regular Member
Joined
Nov 22, 2018
Messages
286
Reaction score
106
as the title explains,
need help from the coding gods on how to "find & replace" link / text that's in the wordpress's wp_postmeta, meta_value,

it's a repeatable_field,
I've tried using the following codes:

update wp_postmeta set meta_value = replace(meta_value, 'test_link1', 'test_link2');

but after updating in phpmyadmin "sql" section,
the link has been successfully updated,

but when you go to the post the link connected to, it's MISSING?!
help anyone who can point me in the right direction in changing the codes I'm using?

I've used the above code with finding and replacing text, url etc in wp_posts, post_contents with no probelms,
maybe i'm coding wrong?

can anyone point me in the right direction?
please help~
 
Back
Top