mysql update join

update cec_item_lib a  inner join cec_item_info_lib b on a.item_id = b.item_id set a.status =10 where substring_index(b.categroy,';',1)  in ("699","703","807","13529","1410","4978","4979","12323","4902","4105","4117","4108","5272","12402","14692","14374","7191","7192","12854") ;