PHP PDO bindValue

Question

I've been trying to use bindValue that can replace the whole search string with variable inside like below, but it doesn't works. Is there anyway I can do something similar?

if ($_POST['filter_group'] == "") {
      $filterGroup = "donorsGroups_IDs IS NOT NULL";
} else if ($_POST['filter_group'] == "N/A") {
      $filterGroup = "donorsGroups_IDs IS NULL";
} else {
      $filterGroup = "find_in_set('" . $_POST['filter_group'] . "',donorsGroups_IDs)";
}

$stmt = $CONN->prepare("SELECT * FROM table WHERE ID= :id AND :filterGroup");

$stmt->bindValue(':filterGroup', $filterGroup, PDO::PARAM_STR);

question from:https://stackoverflow.com/questions/65833946/php-pdo-bindvalue

Answer 1

Waitting for answers