Introducing Quests: Tailored gamification & bridging in-person events with your community Mike Gitkos Friday at 12:39 PM2 days
Posted September 2, 201212 yr in a ccs database (IP_ccs_custom_database_4) I have a field for each entry ( record_comments_queued ) that I need to change to 0 throughout all 130 entries. I have never done something like this and wanted to try (I am using test database to do it) this way instead of d/l sql and doing find/replace. would it be something based on this?UPDATE table_name SET field1=new-value1, field2=new-value2 [WHERE Clause]
September 2, 201212 yr Author hmm I think I got itUPDATE IP_ccs_custom_database_4 SET record_comments_queued=0 seems to work on test database
September 2, 201212 yr Yes that is the way to do it as long as you want all record_comments_queued columns set to zero.
September 2, 201212 yr Author yup, I tested on 2 databases before doing it on live and it did exactly as I needed. thanks for confirming, I am very inexperienced with that,
Archived
This topic is now archived and is closed to further replies.