Replace html style attribute with an MySQL query

Question

We are in the process to update an existing WordPress website and imported posts from one site to another. On the old website we used a WYSIWYG editer and all the posts have styles embedded in them Example:

Content

Expected output:

Content

Now I'm looking for a way to remove the style tag from the html elements. Self I was thinking about an MySQL query but have trouble to figuring out how to preg_replace in it. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

If you want to perform the migration on database level, I would recommend to add a new column to your post table so you can first create a copy of your old data and then compare the results of a migration script. After adding the new column, you could use REGEXP_REPLACE as part of an UPDATE to copy the data into the new column. You may have to change the regular expression syntax so it catches all characters you encounter in the "style" section but this could be a start: UPDATE post_table SET stripped_text = regexp_replace(original_text, ' style="[[:alnum:][:digit:][:space:];,:\(\)\'\-\.]+"', '') Examine the data and see if the results are OK, repeat until the result is good enough. Rename your original post column ("original_text" in my sample) to something like "orignal_backup" and your new column ("stripped_text" in my example) to the original post column's name. More information regarding character classes in MySQL REGEX can be found here.