{"id":5185,"date":"2026-08-30T09:30:33","date_gmt":"2026-08-30T00:30:33","guid":{"rendered":"https:\/\/donguri3.net\/server-tech\/rss-validator-cleanup-mysql-2\/"},"modified":"2026-08-30T09:30:35","modified_gmt":"2026-08-30T00:30:35","slug":"rss-validator-cleanup-mysql","status":"publish","type":"post","link":"https:\/\/donguri3.net\/en\/server-tech\/wordpress-blog-seo\/rss-validator-cleanup-mysql\/","title":{"rendered":"Improving RSS Feeds: Resolving Warnings in RSS Validator and Removing Attributes with MySQL"},"content":{"rendered":"

In a previous article, we used the W3C Feed Validator<\/strong> to validate the WordPress RSS feed. At that time, we confirmed its well-formedness as XML and cleared the basic checks. However, in reality, issues remained where some RSS readers and apps failed to display posts correctly due to extraneous attributes. Therefore, this time we used the official RSS Advisory Board Validator<\/a> to check the feed more strictly.<\/p>\n

Checking with the RSS Validator<\/h2>\n

Upon verification with the Validator, we found that numerous attributes originating from Gutenberg and plugins still remained, such as:<\/p>\n

    \n
  • data-start, data-end<\/li>\n
  • data-spread<\/li>\n
  • data-col-size<\/li>\n
  • data-pm-slice<\/li>\n<\/ul>\n

    While these attributes do not affect browser rendering, they are unnecessary in RSS feeds and can become a factor in reducing compatibility.<\/p>\n

    Batch Removal Using MySQL<\/h2>\n

    Post contents are stored in the post_content<\/strong> column of the wp_posts<\/strong> table. Therefore, we accessed MySQL directly to remove the unnecessary attributes.<\/p>\n

    \n-- Remove data-start\nUPDATE wp_posts\nSET post_content = REGEXP_REPLACE(\npost_content,\n'[[:space:]]data-start="[^"]*"',\n''\n)\nWHERE post_content REGEXP 'data-start=';\n\n-- Remove data-end\nUPDATE wp_posts\nSET post_content = REGEXP_REPLACE(\npost_content,\n'[[:space:]]data-end="[^"]*"',\n''\n)\nWHERE post_content REGEXP 'data-end=';\n\n-- Remove data-spread\nUPDATE wp_posts\nSET post_content = REGEXP_REPLACE(\npost_content,\n'[[:space:]]data-spread="[^"]*"',\n''\n)\nWHERE post_content REGEXP 'data-spread=';\n\n-- Remove data-col-size\nUPDATE wp_posts\nSET post_content = REGEXP_REPLACE(\npost_content,\n'[[:space:]]data-col-size="[^"]*"',\n''\n)\nWHERE post_content REGEXP 'data-col-size=';\n\n-- Remove data-pm-slice\nUPDATE wp_posts\nSET post_content = REGEXP_REPLACE(\npost_content,\n'[[:space:]]data-pm-slice="[^"]*"',\n''\n)\nWHERE post_content REGEXP 'data-pm-slice=';\n\n-- Remove data-is-only-node\nUPDATE wp_posts\nSET post_content = REGEXP_REPLACE(\npost_content,\n'[[:space:]]data-is-only-node="[^"]*"',\n''\n)\nWHERE post_content REGEXP 'data-is-only-node=';\n\n-- Remove data-is-last-node\nUPDATE wp_posts\nSET post_content = REGEXP_REPLACE(\npost_content,\n'[[:space:]]data-is-last-node="[^"]*"',\n''\n)\nWHERE post_content REGEXP 'data-is-last-node=';\n\n-- Remove data-blogcard\nUPDATE wp_posts\nSET post_content = REGEXP_REPLACE(\npost_content,\n'[[:space:]]data-blogcard="[^"]*"',\n''\n)\nWHERE post_content REGEXP 'data-blogcard=';\n\n-- Remove data-attributes\nUPDATE wp_posts\nSET post_content = REGEXP_REPLACE(\npost_content,\n'[[:space:]]data-attributes="[^"]*"',\n''\n)\nWHERE post_content REGEXP 'data-attributes=';<\/pre>\n
     <\/pre>\n
    Here, we used [[:space:]]<\/code> to ensure reliable removal even if line breaks or tabs are present in addition to spaces. Since MySQL 5.x does not support REGEXP_REPLACE<\/code>, you would need to repeat REPLACE<\/code> for each individual attribute.<\/p>\n
    <\/pre>\n
    Verification<\/h2>\n
    <\/pre>\n
    After executing the SQL and checking again with the RSS Validator, the warnings related to these attributes disappeared. We also confirmed that articles are now displayed properly in feed readers.<\/p>\n
    <\/pre>\n
    Future Tasks<\/h2>\n
    <\/pre>\n
    Warnings still remain for attributes originating from image tags, such as fetchpriority<\/code>, decoding<\/code>, and sizes<\/code>. Because WordPress adds these automatically, it is safest to add a filter in functions.php<\/code> to remove them only when outputting the feed. In the next post, I plan to summarize how to strip these attributes and further reduce Validator warnings.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In a previous article, we used the W3C Feed Validator to validate the WordPress RSS feed. At that time, we con […]<\/p>\n","protected":false},"author":4,"featured_media":2124,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"en_US","_original_post":"https:\/\/donguri3.net\/?p=2120","footnotes":""},"categories":[1166],"tags":[551,807,61,799,179],"class_list":["post-5185","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-wordpress-blog-seo","tag-luxeritas","tag-rss","tag-wordpress","tag-799","tag-179","en-US"],"_links":{"self":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/comments?post=5185"}],"version-history":[{"count":1,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5185\/revisions"}],"predecessor-version":[{"id":5188,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/posts\/5185\/revisions\/5188"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/media\/2124"}],"wp:attachment":[{"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/media?parent=5185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/categories?post=5185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/donguri3.net\/wp-json\/wp\/v2\/tags?post=5185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}