Inserir Hifen no CEP - Insert into an existing value

UPDATE yourtable
SET
  zip = CONCAT_WS('-', SUBSTR(zip, 1, 5), SUBSTR(zip, 6))
WHERE
  LENGTH(zip)=9

Descobrir o ip exato do seu site - Find the exact domain from your site

$host= gethostname();
$ip = gethostbyname($host);

echo $ip;