如何使用LIKE语句创建PDO参数化查询？

$conn = new PDO("mysql:host=localhost;dbname=myDB", "username", "password");
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$stmt = $conn->prepare("SELECT * FROM table_name WHERE column_name LIKE :search_term");

$search_term = "%" . $_POST["search"] . "%";
$stmt->bindParam(':search_term', $search_term, PDO::PARAM_STR);

$stmt->execute();

$result = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($result as $row) {
    echo "ID: " . $row["id"] . " - Name: " . $row["name"] . "<br>";
}