getConnection(); // Update all services to have branches [1,2] $stmt = $conn->query('SELECT id FROM services'); $services = $stmt->fetchAll(PDO::FETCH_COLUMN); $stmt = $conn->prepare('UPDATE services SET available_branches = ? WHERE id = ?'); foreach($services as $id) { $stmt->execute(['[1,2]', $id]); } echo "Updated " . count($services) . " services with branches [1,2]
"; echo "Go to Services"; ?>