Removing Visual Composer & Shortcodes From Wordpress Content

remove-visual-composer-shortcodes.md

Adding @k1sul1's suggestion from the comments as it's more concise than what I had before:

I just wanted them all gone, so I ran this in the MySQL shell.

UPDATE wp_posts SET post_content = REGEXP_REPLACE(post_content, "\\[\/?vc(.*?)\]", "");

Note the double backslash. If you forget it, you'll replace all v's and c's with nothing, and the shortcodes will still be there. This works for other shortcode as well, just replace vc.

Take a backup beforehand.

Please, can you help me?

I'm trying deleting

<!-- wp:uagb/lottie {"block_id":"ba1f8cd1","lottieURl":"https://assets5.lottiefiles.com/packages/lf20_hd8ztfyp.json"} /-->

in all post, but block_id and url change.

@alelazcano Please try running the following SQL query, but make sure to take a backup of the database before executing any queries:

UPDATE wp_posts SET post_content = REPLACE(post_content, SUBSTRING( post_content, LOCATE('<!-- wp:uagb/lottie ', post_content), LOCATE('/-->', post_content, LOCATE('<!-- wp:uagb/lottie ', post_content)) + 4 - LOCATE('<!-- wp:uagb/lottie ', post_content) ), '' ) WHERE post_content LIKE '%<!-- wp:uagb/lottie %/-->';

This query will remove the specific block from all posts. Let me know if you encounter any issues or need further assistance.