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 2.28 hours from now. Thank you for your understanding.

This topic contains 1 reply, has 2 voices.

Last updated by Diego Pereira 12 months ago.

Assigned support staff: Diego Pereira.

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

inY

Hi,

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
Supporter

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: https://wpml.org/purchase/support-policy/

You can find how WPML uses database tables here: https://wpml.org/documentation/support/wpml-tables/. Also you can find out API documentation here: https://wpml.org/documentation/support/wpml-coding-api/wpml-hooks-reference/

Please take a look at this similar ticket: https://wpml.org/forums/topic/extracting-mysql-post-content-per-language/ - perhaps you can adapt this code to your needs.

If you need some help, we have a list of experienced contractors available here: https://wpml.org/contractors/

All the best,
Diego