WordPress Permalink Manager Plugin: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| Line 92: | Line 92: | ||
# or if you want to reset changes | # or if you want to reset changes | ||
ROLLBACK; | ROLLBACK; | ||
</syntaxhighlight> | </syntaxhighlight><br /> | ||
* Bulk edit date of Media Files to update with this date: 1999-09-13 | |||
* phpMyAdmin: Query Database, Export (at bottom of query, not on Tab) to CSV | |||
SELECT ID FROM wp_posts WHERE post_date='1999-09-13*'; | |||
* Textpad: Remove " characters using ALT & Mouse OR Replace with nothing, Replace, Regular expression Checkbox, Find: \r (carriage return), Replace: , | |||
* Clear Temporary Table: TRUNCATE TABLE LifeOfTheSaltonSea_org_WP.TT2; | |||
* Save original SLUG Names; | |||
INSERT INTO LifeOfTheSaltonSea_org_WP.TT2 (ID, post_name) | |||
SELECT ID, post_name | |||
FROM LifeOfTheSaltonSea_org_WP.wp_posts | |||
WHERE post_date LIKE '1999-09-13%'; | |||
* Modify the SLUG (post_name) | |||
UPDATE LifeOfTheSaltonSea_org_WP.wp_posts | |||
SET post_name = CONCAT("recent-history/images/", post_name) | |||
WHERE post_date LIKE '1999-09-13%'; | |||
<br /> | |||