update opl_preference set val=replace(val,'http:','https:'),valShow=val where var='unionSvcUrl' && val regexp '^http:';
