I'm trying to change all instances of a Moodle module with SQL, e.g.:
- From: Label > Activity completion = Students can manually mark the activity as completed
- To: Label > Activity completion = Do not indicate activity completion
I'm not sure where I can find these settings in the Moodle database. I'd like to run a SQL query like:
UPDATE `mdl_[tablename]` SET `[columnname]` = '[value]' WHERE `mdl_[tablename]`.`course` = 4
...but I suspect it's not that simple.
Thanks in advance,