UPDATE lportal.CChannelAccountEntryRel caer JOIN lportal.CommercePriceList cpl ON caer.classPK = cpl.commercePriceListId JOIN lportal.ClassName_ cn ON caer.classNameId = cn.classNameId SET caer.classNameId = (SELECT classNameId FROM lportal.ClassName_ WHERE value = "com.liferay.commerce.price.list.model.CommercePriceList") WHERE cn.value = "com.liferay.commerce.discount.model.CommerceDiscount";