value IN (value1, value2, value3,...)

Using IN operator

"SELECT * FROM MyTableName WHERE MyColumnName IN (12, 16, 22)"

Example using an array

  $sql = "SELECT * FROM MyTableName WHERE MyColumnName IN ( ";  
  $NotFirst = False;
  foreach ($MyArray as $MyArrayItem)
  {
    if ($NotFirst)
      $sql .= ",";
    $sql .= $wpdb->prepare("%d", $MyArrayItem);
    
    $NotFirst = True;
  }
  $sql .= " )";