String[] nameFilters = new String[]{'%Sale%', '%Opportunity%', '%Catalog%'};
List<Pricebook2> myList =
[select Name
from Pricebook2
where name LIKE :nameFilters
];
for (Pricebook2 rec : myList) {
rec.Is_Auto_Maintained__c = true;
rec.Price_Type__c ='Net';
}
update myList;