Export permalinks from database

  • Hi guys,
    Is there any quick way, preferably via a SQL command which I can enter into PHPMyAdmin, which will export EVERY permalink from the database? If I published a blog post in four different categories then I would require all four different permalinks to be included in the exported list (this of course also includes archives and whatnot).

    Any help is much appreciated.

Viewing 2 replies - 1 through 2 (of 2 total)

  • SQL: SELECT guid FROM wp_posts WHERE 1=1
    You can then export the results by clicking on the “Export” link on the (very) bottom of the result page.

    But those are the ugly permalinks.
    How do you convert them into pretty permalinks?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Export permalinks from database’ is closed to new replies.