Try this query, remembering to change out your_posts_table with the proper name in your database. Using CONCAT, you can add any number of strings, just pass post_name to add your changes before/after.
update your_posts_table
set post_name = CONCAT('pre-', post_name)
- More info on MySQL CONCAT
- Note: Use a
WHEREclause if you only want to update specific posts.
Related Posts:
- Where is the old post permalink slug stored?
- Use category base slug in posts’ permalink
- How to automatically generate a unique random slug
- Post slugs and images cannot have same name?
- Change the Slug of Post Type post to baseurl/post/%postname%
- How to control which category will be picked for the slug of a post?
- how to get permalink using sql
- Change slug with custom field
- How to handle broken links created by permalink/slug changes?
- Visting slug for ‘post’ post type shows 404 not archive?
- how do i add posts-page slug before posts slug in permalinks
- How to 301 redirect from url with post id to permalink with post name (slug)?
- My post permalinks are always the same
- post_name is not stored until post is published… where should I store my slug until it goes live then?
- Change permalinks in posts via SQL
- How to Check if a Page Exists by URL?
- Custom Post Types, slug, archive and SEO plugins
- Custom permalink structure only for default posts
- Change permalinks for post type ‘post’ only
- Export WordPress Posts and Meta Information in CSV format
- Different permalink for posts and authors
- Pretty URL with add_query_var
- get_permalink returns default link
- Group Posts by First Letter of Title
- Keep getting same permalink with WP_Query?
- Determining Slug Before and After Edit
- Why can posts never have a number as the link?
- Must permalinks always point to single post pages?
- How to allow slashes in single posts when i click in the edit permalink button
- How to update all post at once?
- Post custom permalink results in 404 for archive page
- Some posts returning 404 instead of displaying post
- Custom post type single (permalink) throws a 404 error
- Link for the page archive for posts, like using custom post types with get_post_type_archive_link
- Post in Multiple Categories to stay in current category (permalink, next previous post link)
- Use Cron to modify posts via sql
- generate unique slug while inserting post
- Sql syntax error
- Random post permalink
- How do I get the slug of a custom taxonomy category of a post?
- What Defines What Category A Post Picks (if in multiple)
- get_permalink executes link without https
- Permalink Settings: optional settings doesn’t apply to editor
- get posts and postmetas in assoc array
- Custom post type permalinks breaking due to 3.1 bug fix
- How can a guest view the “Pending Review” Post?
- Create pretty permalink for a post knowing the permalink structure
- Changing my permalink structure – will new layout conflict with existing page?
- How to change the page break URL from ../post/2 to …/post/page2/
- Link post permalinks to subdirectory /post
- change default post archive page link
- How to get posts by multiple post slugs? [duplicate]
- Define a name to the posts slug
- Remove permalink from images when inserting into post
- Automaticly add slug to posts
- Remove the Edit button in posts for permalinks on certain user roles? WP 3.3
- How do I find which articles are missing a featured image in The WordPress database?
- Dynamically generate child-URLs for posts or custom posts
- Get the most repeated post contents from a search?
- Adding parent pages to posts
- Multiples Empty Posts were created and cannot delete them
- Plain permalinks not working!
- Delete WordPress posts from URL list sql query
- SQL query to retrieve all the records that have not indicated category
- Removing rel=”nofollow” from links posted in Post Content
- How to change permalink on post click on post listing page
- Changing Permalinks for Default Post type to reflect navigation
- How should I add links to other pages/posts from my post?
- WordPress not opening posts with only numbers if permalink is post_name
- Using permalinks, category slugs, and tag slugs
- Problem with permalink routing?
- Move first half of posts to one parent page, second half to the other page
- How to verify wp user password by sql query in wp? [closed]
- Get ALL post ID’s export list (Only id’s. Php or sql not important )
- How to check a post exist when the permalink has post id in it?
- After database migration, posts not showing up in dashboard
- How to do set post permalinks using 6 digit random unique function?
- Switch to page template when using post permalink
- How to have posts have a parent in permalink like site.com/blog/postname
- Trying to use AngularJS with WordPress without any API
- Automatically add date to the auto generation of post slug
- How could I change my Permalink from blog to custom structure? [closed]
- Remove Custom Post Type Slug and add Custom Taxonomy to Permalink Structure?
- Any way for get_next_post() to use the actual post order instead of publish order?
- Permalink doesn’t get displayed in Twitter button (Local WordPress problem?)
- Retrieve post ID from “querying” URL
- hiding permalink in admin if the user is subscriber
- Why does WP_Post not contain its permalink?
- the_permalink() not working in a root installation
- When changing pages to posts, how do you set up 301 redirects for the page URLs?
- How to get a post’s content? [closed]
- Disable WordPress Archive Conflict Check
- WordPress website loads more posts than expected
- SQL Command for restoring trashed comments
- Second get_permalink inside loop points to wrong URL
- Two Custom Post Types with Identical Articles Competing for the same Slug
- WordPress custom post type with folder structure in slug
- Custom Permalink Structure for Pages & Posts
- my post slug gets really long and I can’t change it
- Replace image name on upload to the new post name on front-end form