Special Content

Get rid of this Strict Standards warning WooCommerce: get_current_screen not working with multi language Can’t login on WordPress Force HTTPS using .htaccess – stuck in redirect loop WordPress: Ajax not working to insert, query and result data

Home Science, Programming and Technology WordPress SQL To delete characters from a column

SQL To delete characters from a column

February 19, 20232 Views

placeholder

I have a wordpress site. I want to delete the first 15 characters from every post on the site.

I believe the table is wp_posts, and the column is post_content

What would be the sql that I execute from my database manager?

Post Views: 2

Leave a Reply Cancel reply

You must be logged in to post a comment.

1 comment

Anonymous says:

February 19, 2023 at 2:33 pm
Try this:
```
UPDATE wp_posts SET post_content = substr(post_content, 16);
```
read more…
Log in to Reply