GreatestSwordsman
Reputation: 1185
SQL To delete characters from a column
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?
Upvotes: 1
Views: 223
Answers (1)
JK.
Reputation: 5136
Try this:
UPDATE wp_posts SET post_content = substr(post_content, 16);Upvotes: 3
Related Questions
- Removing unwanted character from column
- remove character on sql
- How do you remove certain characters from a string in MySQL?
- Delete some characters from a column in MySQL
- Delete some characters from mysql row
- Select Query to Remove these characters in Mysql
- MYSQL remove word from a column in a table
- How to remove a certain character from a column in a table
- Mysql Query to remove unwanted letters from the rows
- Mysql delete a certain char