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 permalink structure only for default posts
- Pretty URL with add_query_var
- get_permalink returns default link
- Group Posts by First Letter of Title
- Must permalinks always point to single post pages?
- Post custom permalink results in 404 for archive page
- Custom post type single (permalink) throws a 404 error
- Post in Multiple Categories to stay in current category (permalink, next previous post link)
- How do I get the slug of a custom taxonomy category of a post?
- What Defines What Category A Post Picks (if in multiple)
- Custom post type permalinks breaking due to 3.1 bug fix
- How can a guest view the “Pending Review” Post?
- change default post archive page link
- How to get posts by multiple post slugs? [duplicate]
- Define a name to the posts slug
- Automaticly add slug to posts
- How do I find which articles are missing a featured image in The WordPress database?
- Multiples Empty Posts were created and cannot delete them
- Delete WordPress posts from URL list sql query
- Removing rel=”nofollow” from links posted in Post Content
- How to change permalink on post click on post listing page
- WordPress not opening posts with only numbers if permalink is post_name
- After database migration, posts not showing up in dashboard
- Switch to page template when using post permalink
- 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?
- Permalink doesn’t get displayed in Twitter button (Local WordPress problem?)
- Disable WordPress Archive Conflict Check
- WordPress website loads more posts than expected
- 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
- custom word in custom permalink structure
- Unabled to Change Permalinks – Even Using the “Edit” (Resets to Original Permalink on “Update”)
- post type slug vs page slug
- Internal linking to posts permalink fail because of spaces and stripe at postname
- Link post images to post
- Export all posts to import as product items
- Problems with WordPress in subfolder, posts show a blank page
- how to create a sub section in posts
- Rewriting blog permalinks
- Change permalinks for posts & for custom post types
- SQL DELETE multiple post_meta on single and multi-sites
- Permalink Short code showing unnecessary link text inside the loop
- Get post slug and match with menu item slug to change css
- Bulk find & replace on WordPress posts/pages (minus image paths)
- How to set the post permalink using the WordPress REST API?
- Does having category name in permalinks affect SEO when having a post in multiple categories?
- unable to display two post per page in wordpress front-page.php
- insert post fails after multiple postings
- Prevent Archive URLs
- Custom Post Types and Broken Permalinks
- Custom permalink for wordpress page / post
- Word /blog/ in slug post, problems in CPT. Solutions?
- Permalink structure for two seperate blogs
- Adding wordpress posts using phpmyadmin
- How to give priority to page than to posts permalink structure?
- Append a random string to a post permalink
- Fixing the WP Post Object for Custom Route
- All my posts don’t show, only the headline is displayed on the homepage
- How to change post template via url?
- Post as frontpage – avoid duplicate content
- Posts in Page – How to customize the URL?
- Is there a way to change the complete URL of the blog post for a redirecting tracking link?
- WordPress with static posts page and custom permalink structure doesn’t find posts with numeric permalinks
- Can’t seem to replicate permalink structure for localhost development site
- WordPress rewrite url help needed
- Permalink of some posts change
- My posts section for logged in user
- How to mix pages and sub-categories in a url
- Changing permalink of custom category
- Special Query: Title, Terms, Content – %LIKE%
- TCPDF and permalinks
- Overwrite URL on blog posts
- WordPress sub-posts and permalinks
- 301 Redirecting posts without %postid% (just %post_name%) in permalink to ones with %post_name%_%postid%
- How do I add /blog/ on my permalink without affecting the portfolio project types permalink?
- Permalink remain the same on each page
- Read more link not working [closed]
- The page that displays Posts on homepage
- How to change Permalinks only for Blogposts
- Permalink structure for two separate blogs
- Blog posts are not appearing as subs of Blog Page
- How to add paraent in Blog post URL in wordpress