1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Editing Mysql table en masse in phpmyadmin

Discussion in 'MySQL' started by chops, Oct 27, 2009.

  1. #1
    I have a large Open realty site and need to edit the database but am a novice in this area.
    I have backed up the database.
    I have logged into phpmyadmin.

    On the left side I have a list of tables and have found default_en_userdb

    Within this table it is the userdb_can_edit_expiration which needs to be editted.

    I need to change all the yes values to no.

    I believe there is a certain command I can enter into somewhere which will do the job??
    Any help greatly appreciated!
     
    chops, Oct 27, 2009 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    ok.. here is what i have understood and solution based on it.

    you have a table "default_en_userdb" which has column "userdb_can_edit_expiration" having "yes" and "no" as values. Now you wish all the rows for this column to have value as "no".

    following query might be helpful

    UPDATE default_en_userdb SET userdb_can_edit_expiration = 'no';

    hope you know how and where to execute it :)
     
    mastermunj, Oct 27, 2009 IP
    chops likes this.