After running the following query SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes'; I’ve found I got 1587 autoloading options values, mostly belonging to custom fields values; since they start with category or _category I am looking for a way to SELECT and UPDATE the autoload value for all at once. I guess an SQL query would be the fasted method but I am not sure about the correct syntax.
batch UPDATE autoload value in wp_options table
