USE provisioning;
SET AUTOCOMMIT=0;

UPDATE voip_peer_rules SET callee_pattern = REPLACE(callee_pattern, '^sip:', '^') 
  WHERE callee_pattern LIKE '^sip:%';
UPDATE voip_peer_rules SET caller_pattern = REPLACE(caller_pattern, '^sip:', '^') 
  WHERE caller_pattern LIKE '^sip:%';

COMMIT;
