Online PHP editor | refs for AbcAR

<?php $db = new PDO('sqlite::memory:'); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); $db->exec('CREATE TABLE example (name TEXT, vals TEXT);'); $insert = $db->prepare('INSERT INTO example (name, vals) VALUES (?, ?)'); $insert->execute(array('row1', '1,3,4')); $insert->execute(array('row2', '1')); $insert->execute(array('row3', '5,6')); function csv_intersection($vals, $search) { $vals_array = explode(',', $vals); $search_array = explode(',', $search); $intersection = array_intersect($vals_array, $search_array); return implode(',', $intersection); } $db->sqliteCreateFunction('intersection', 'csv_intersection', 2); $stmt = $db->prepare('SELECT name, vals FROM example WHERE intersection(vals, ?)'); $stmt->execute(array('1,2,3')); foreach ($stmt as $row) { var_dump($row); }