Skip to navigation
Linking 2 taxonomy tables of wordpress and update one
29.05.25
``` CREATE TEMPORARY TABLE t( SELECT x.term_taxonomy_id ,wx.description FROM `wp_term_taxonomy` AS x LEFT JOIN wp_terms AS t ON x.term_id = t.term_id LEFT JOIN wp9735terms AS wt ON t.slug = wt.slug LEFT JOIN wp9735term_taxonomy AS wx ON wt.term_id = wx.term_id and wx.taxonomy = 'product_brand' WHERE x.taxonomy = 'product_brand' and wx.taxonomy is not null and wx.description != '' order by t.name ); UPDATE wp_term_taxonomy x LEFT OUTER JOIN t t ON x.term_taxonomy_id = t.term_taxonomy_id SET x.description = t.description WHERE x.description = '' AND t.description is not null ```
Reply
Anonymous
Information Epoch 1748834666
Files are bags of bytes.
Home
Notebook
Contact us
