Blog Documentation Book a Demo
Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Find/Replace in phpMyAdmin?

garvingarvin
edited January 2007 in Vanilla 1.0 Help
I am wondering if there is a way I can do a mass find/replace in my Vanilla db. Basically, I have a bunch of discussions called one name, and I want to change them all to another. Is there a way to do this without going into every topic (150 +/-) and editing the name?

Comments

  • bjrnbjrn
    edited January 2007
    If it's an exact name, you could run an SQL query perhaps?
    UPDATE table SET field="New name" WHERE field="Old name"

    (Always remember to make backups of important things before running queries!)
  • Max_BMax_B New
    For substring matching:
    UPDATE LUM_Discussion SET Name=REPLACE(Name, 'Old name', 'New name') WHERE field LIKE 'Old name'
    Not tested however, be safe.
  • garvingarvin
    Eh. Anyone have a tested method? : ) I'll try this soon, but will wait to see if anyone has a tested method for me to try.
  • StashStash ✭
    Chicken! =D
  • rabidgopher04rabidgopher04
    edited January 2007
    @garvin: just backup your db then run the code. If it goes FUBAR then restore the db and all is well again!
This discussion has been closed.