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!
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