ป้ายกำกับ: Regular

SELECT 
  ID,
  post_title,
  CONCAT_WS('\n',
    REGEXP_SUBSTR(post_content, '<!-- wp:table[^>]*-->'),
    REGEXP_SUBSTR(post_content, '<figure class="wp-block-table[^"]*">')
  ) AS `original`,
  CONCAT_WS('\n',
    '<!-- wp:table {"hasFixedLayout":false,"className":"is-style-stripes"} -->',
    REGEXP_REPLACE(
      REGEXP_SUBSTR(post_content, '<figure class="wp-block-table[^"]*">'),
      '<figure class="wp-block-table(\\s+align(center|wide|full))?[^"]*">',
      '<figure class="wp-block-table\\1 is-style-stripes">'
    )
  ) AS `modify`
FROM wp_posts
WHERE post_content LIKE '%<!-- wp:table%'
  AND post_type IN ('post', 'page')
LIMIT 5;

UPDATE wp_posts
SET post_content = REGEXP_REPLACE(
  REGEXP_REPLACE(post_content, '<!-- wp:table[^>]*-->', '<!-- wp:table {"hasFixedLayout":false,"className":"is-style-stripes"} -->'),
  '<figure class="wp-block-table(\\s+align(center|wide|full))?[^"]*">',
  '<figure class="wp-block-table\\1 is-style-stripes">'
)
WHERE post_content LIKE '%<!-- wp:table%'
  AND post_type IN ('post', 'page');