This is the technical support forum for WPML - the multilingual WordPress plugin.

Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.

Our next available supporter will start replying to tickets in about 6.45 hours from now. Thank you for your understanding.

This topic contains 1 reply, has 2 voices.

Last updated by Diego Pereira 1 year, 7 months ago.

Assigned support staff: Diego Pereira.

Author Posts
October 23, 2018 at 9:32 am #2841691



I am trying to bulk update blog content from phpmyadmin by using :

UPDATE wp_posts SET post_content = replace(post_content, 'OLD TEXT', 'NEW TEXT');

I have language A & B, i only want to bulk update the content from language B.

How can i achieve that?

October 23, 2018 at 5:15 pm #2843632

Diego Pereira

Languages: English (English ) Spanish (Español ) Portuguese (Brazil) (Português )

Timezone: America/Sao_Paulo (GMT-03:00)

Hello @iny, welcome to the WPML support Forum!

Unfortunately, according to our support policy, we cannot produce custom code solutions:

You can find how WPML uses database tables here: Also you can find out API documentation here:

Please take a look at this similar ticket: - perhaps you can adapt this code to your needs.

If you need some help, we have a list of experienced contractors available here:

All the best,