SELECT Json_extract(showObj, "$.skues[0].shopPrice","$.skues[0].goodNumber") from baseSearch where JSON_CONTAINS(catIds, "2097") and isOnSale =1
update baseSearch set showObj = json_set(showObj, "$.skues[0].shopPrice",0,"$.skues[0].goodNumber",0,"$.skues[0].isAdvanceGoods",1) where JSON_CONTAINS(catIds, "2593") and isOnSale =1