$sql = "SELECT badge_id, badge_name_h, badge_name_v 
   FROM badges 
   WHERE (`badge_name_h` LIKE ?) OR (`badge_name_v` LIKE ?)";
  $search="'%{$_GET['name']}%'";
  $stmt = $mysqli->prepare($sql);
  $stmt->bind_param('ss', $search, $search);