Results 1 to 2 of 2
Thread: Query Help
Feb 2, 2002, 19:53 #1
I have forum like this one need some help with a query.
I have been using username1 for my admin name on my forum. Now I want to change my username to say username2. By doing this I need to run a query in phpmyadmin to update a table called post and a table called thread. I need to run a query on both tables that will change username1 to username2. Any ideas on this query.
post fields in post table is called username and thread posterusername and lastposter
both have a userid in the table and for this user name it is userid7
Hope this makes sense.
Feb 3, 2002, 00:53 #2
You need something similar to:Code:
UPDATE MyTable SET AdminName = 'username2' WHERE AdminName = 'username1'