You need to programmatically set the slug as you do so. An SQL trigger could do the trick. Don’t forget to mind duplicate slugs as you write it.
Else, instead of publishing using the database, write a php script that calls the WP API.
Related Posts:
- How to get the clean permalink in a draft?
- How to make draft posts or posts in review accessible via full url / slug?
- wp_publish_post to saved draft, permalinks broken
- Need help with add_rewrite_rule
- Removing Parent Page(s) from Permalink
- Prevent WordPress from abbreviating-long-slugs…-in-the-admin
- Page begins with number, WordPress adds 2
- Permalinks to Custom does not work (out of box)
- Why don’t WordPress post slugs allow accents?
- Permalink Issues by Installing WordPress in Subdirectory / Subfolder
- Multi-language permalink in qtranslate
- Modify get_permalink with a specific filter
- Include Taxonomy slug in post url
- Nice RSS Feed URLs for each custom post type
- How to set permalink to fetch all children custom posts with parent post in wordpress?
- Rewrite url / permalink for default archive – yearly / monthly
- Should I use relative or absolute urls when pointing to internal pages
- WordPress on VirtualBox – no pretty permalinks
- permalinks has -2 with post name structure. why?
- How can I change permalinks to use a different domain and path from where the blog is hosted?
- Gutenberg Editor: dynamicaly change slug field with an ACF field
- Apostrophe in permalink results in page not found
- How to generate random numeric slugs for a custom post type?
- WP Site in subdirectory Joomla! Site – Permalinks not working
- How to get full content including template HTML
- I copied my site to another site but all links point to old site
- WordPress on Ubuntu 12.10: permalinks problem
- wordpress api using rest_route for other pages
- Infinite redirects after changing the permalink of a page
- Permalinks settings page blank
- Remove custom taxonomy base from URL
- How to have extra permalink for posts
- Trouble with numeric permalinks after 4.3.1
- Editing Pages Give 404 Error After WordPress Upgrade in Admin Panel
- How to get post object on blog template
- Illegal characters in URLs
- How to make /search/ without parameters not return a 404?
- WordPress auto generates small medium and large of an image on upload, how can we guess their links?
- Error updating pages, and linking to pages (permalink error)
- Plain to postname permalinks not working
- Permalinks dropping after 3-4 weeks with no changes in theme or plugins
- WordPress Sub domain
- How can i have a custom post type with more slugs for each post?
- Create a PHP page to refresh the permalink on a custom table
- Google webmaster duplicate url issue with /page/01 /page/400
- URL rewriting: removing the site’s basename for a specific category
- Migrated from Windows to Linux. Any bulk methods for fixing case sensitivity?
- Custom permalink for specific category
- Unable to get /%postname%/ permalinks working, 404 on all links
- Permalink structure between 2 custom post types and a taxonomy
- How to use all tags in post permalinks
- Stop Images Linking to Themselves?
- Remove parent page from url
- Remove “attachment/” from the URL of attachment pages
- How do I change the permalink structure without getting 404s?
- 404 on internal pages, in all sites in my local server
- how to alter permalink in wordpress?
- Adding User Info to Permalink of User pages – is it neccessary?
- add_rewrite_rule – Page Slug from “/foo-bar/” to “/foo/bar/”
- Permalink will not change – it wants to have -2 slug [duplicate]
- Permalinks 404 after Subdirectory to Root Migration
- optional parameter in permalink structure
- Get a link to paged() part?
- Custom permalink structure only saves with index.php inserted
- Two custom taxonomies in permalink structure
- Blogger To WordPress Permalink Redirection
- What is the simplest way to create a redirect
- the_permalink() not working
- All in One Seo and Permalinks
- Already have htaccess but permalink settings not working. Getting 404
- How to make different urls for some tags pages
- How can i fix my permalinks?
- Adding custom query var to a single post without redirecting to its root slug
- How to change specific permalink in wordpress site?
- Fire a code when permalinks updated
- Custom structure permalink preventing 404
- Flush rewrite rules with scheduled event (cron)
- I have a 404 error on all my pages! What do I do?
- All files in public_html, Cannot launch WordPress site via wp-admin
- Extra url paths as variable
- Add slug to default post permalinks ONLY
- Propper way to set anchor and url param
- Prevent 301 when a trailing slash added
- Why I had to re-save permalink setting after moving my WordPress site to another hosting provider?
- Do shortcodes in title before permalink is generated
- Permalinks custom base to redirect to archive.php
- How to change URL of my pages?
- Pretty permalinks returning “not found” on localhost and server
- Removing or hiding slug/permalink from htaccess
- Problems with permalinks after update wordpress 4.2
- WordPress Permalink Problem
- Converting WP Page to use full explicit paths?
- Latin character conversion
- Update permalinks
- Losing the original URL when using add_rewrite_rule
- Permalink issues with Ubuntu Server – Infinite loop & Wrong pages
- Post/page without slug
- How to get the perfect WordPress, WooCommerce, Custom Post Type pretty permalinks?
- WordPress keep redirecting me to random URLs
- How to make a permalink variable %year% become two digits instead of four digits?