0

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.

0

Not a hard task at the end. I've managed to do it in two chunks with

UPDATE wp_options SET autoload = 'no' WHERE option_name LIKE 'category%'; and UPDATE wp_options SET autoload = 'no' WHERE option_name LIKE '_category%';

  • Hi i wonder is there any benefit on this? – Michael Rogers Mar 3 '18 at 18:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.