select concat_ws('_', 
  substring_index(url, '_', 1), 
  repeat('*', length(url) - length(substring_index(url, '_', 1)) - 
    length(substring_index(url, '_', -1)) - 2), 
  substring_index(url, '_', -1)) as str from t1;