Visit the LQ Articles and Editorials section
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 07-10-2004, 02:39 PM   #1
Registered: Sep 2003
Distribution: gentoo
Posts: 101

Rep: Reputation: 16
phpmyadmin (or regular mysql) batch column edit?

hey everyone, i have a wordpress blog, but the entries i imported from my old blog got imported as a different author, and so i have about 180 entries in the wp_posts table with author id 1, and about 180 with author id 3. Is there any way i can use phpmyadmin or mysql to change every entry in the table to have the same value for author id?

Old 07-10-2004, 03:06 PM   #2
Registered: Jul 2004
Location: Czech Republic - Roudnice nad Labem
Distribution: Debian
Posts: 253

Rep: Reputation: 33

try: UPDATE wp_posts SET id=1;

thiss will change all values in ID column to 1 in table wp_posts


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
updating a column in MySQL mohtasham1983 Programming 1 10-28-2005 11:01 AM
mysql and phpmyadmin jungleking Linux - Newbie 1 09-17-2005 09:07 AM
How to delete a column in MySQL ? indian Linux - General 2 10-15-2004 02:02 PM
MySQL in batch mode ganninu Linux - General 1 11-20-2003 06:49 AM
Installing phpmyadmin with mysql?? chromelocust Linux - Software 0 04-07-2003 02:25 PM

All times are GMT -5. The time now is 06:27 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration