note 72130 rejected from ref.pdo by nlopess

Note Submitter: ap at andrewprendergast dot com ---- Quick heads up that PDO doesn't allow one to SELECT or DELETE groups of records based on their primary key. For example, the following should return the records with ID 1 & 2: $dbh = new PDO('mysql:host=localhost;dbname=mobop', "root", ""); $stmt = $dbh->prepare("SELECT * FROM news_item WHERE news_item_id IN(?)"); if ( $stmt->execute(array("1, 2")) ) while ( ($row = $stmt->fetch()) ) print_r($row); But it doesn't. The following execute statement fails as well: $stmt->execute(array(array(2,1))) IE, the SQL clauses WHERE ... IN (...) and WHERE ... = ANY (...) does not work with PDO for more than one record.