phpmyadmin - mass edit a field

Discussion in 'PHP' started by Dracubat, Nov 29, 2007.

0
  1. #1
    Hello DP members,

    New to php/mysql. I have phpmyadmin on my server.

    How do I change the input in a specific field (1600 + cells) all at once.

    It is a checkbox that is set to "0" (not active) and needs to be "1".

    Any help is appreciated, hate to mess up the db.

    Thanks in advance,

    Dracubat
     
    Dracubat, Nov 29, 2007 IP
  2. bobb1589

    bobb1589 Peon

    Messages:
    289
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #2
    in phpmyadmin go to the desired table and click on the 'sql' tab

    UPDATE tablename SET fieldname='1' WHERE fieldname='0'
     
    bobb1589, Nov 30, 2007 IP
    Dracubat likes this.
  3. Dracubat

    Dracubat Peon

    Messages:
    485
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thank you very much. Perfect!
     
    Dracubat, Nov 30, 2007 IP