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

  • Utilizando INNER e LEFT JOIN
  • Dream Theater - Stream of Consciousness (Live at Budokan)
  • Associando arquivos JSP (JNLP) ao Java Web Start no KDE 4.x
  • Janela de log like a Log4j
  • Resolvendo o problema de segurança do "TimThumb" do Wordpress
  • How to send a broadcast message on Ubuntu-based distros
  • Verificar se um elemento existe com JQuery

Twitter

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