Carlos Spohr

dev, runner, etc.

  • GestorGuia
  • Blog
  • Java
  • Javascript
  • Databases
  • Linux
  • About
Skip to content

Carlos Spohr

dev, runner, etc.

  • GestorGuia
  • Blog
  • Java
  • Javascript
  • Databases
  • Linux
  • About

Easy way to change author from posts in WordPress

Carlos Spohr–Databases–15/10/201419/09/2018

If you have to change author from lots of posts on WordPress, you can use SQL to save your time:

[sql]UPDATE wp_posts p SET p.post_author = 1 WHERE p.post_author <> 1;[/sql]

Remember! Be careful when you are querying on your database, do a backup before.

Share:

  • Share on Facebook (Opens in new window) Facebook
  • Share on LinkedIn (Opens in new window) LinkedIn
  • Share on X (Opens in new window) X

Post navigation

Fixing wrong charset on gedit
Setup serviio DLNA server on Ubuntu based distros


Gestor Guia

O planejamento financeiro permite você investir seu dinheiro no que realmente faz sentido para a sua vida. Então não perca tempo, sabia como podemmos ajudar você a planejar sua vida financeira e realizar seus sonhos.

Experimentar agora!

Stackoverflow

profile for Carlos A. Junior at Stack Overflow, Q&A for professional and enthusiast programmers

Most read

  • Dicas de nomes #11
  • Adicionando um parâmetro condicional WHERE em um mysqldump
  • Plugin jQuery para geração de senhas
  • É por isso que eu me orgulho de ser Paranaense #1

Twitter

Could not authenticate you.
Powered by WordPress | Theme: Talon by aThemes.