http 换成 https

UPDATE 
    SYS_MENU M 
SET 
    M.href = 
    (
    SELECT 
        CASE WHEN  substr(N.href, 0, 5) = 'http:' THEN  'https:'||substr(N.href, 6)  
        ELSE N.href END href 
    FROM 
        SYS_MENU N
    WHERE 
        M.ID = N.ID
    ) 
    WHERE 
        M.ID = '20a17234cd1f439b87cef0361653b66b'