how do I do this sql queury/execute?

[Dmacleo]

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]

[Dmacleo]

hmm I think I got it

UPDATE IP_ccs_custom_database_4 SET record_comments_queued=0

seems to work on test database

[Royzee]

Yes that is the way to do it as long as you want all record_comments_queued columns set to zero.

[Dmacleo]

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,