note 120247 added to function.sqlite-create-function

The (probably) all too often requested regexp() function actually works just fine. <?php $db = new PDO('sqlite::memory:', null, null, [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]); $db->sqliteCreateFunction('regexp', function($y, $x) { return preg_match('/' . addcslashes($y, '/') . '/', $x); }, 2); $db->query('SELECT ("Things!" REGEXP "^T") result'); ?> ---- Server IP: 72.52.91.14 Probable Submitter: 77.50.25.68 ---- Manual Page -- http://php.net/manual/en/function.sqlite-create-function.php Edit -- https://master.php.net/note/edit/120247 Del: integrated -- https://master.php.net/note/delete/120247/integrated Del: useless -- https://master.php.net/note/delete/120247/useless Del: bad code -- https://master.php.net/note/delete/120247/bad+code Del: spam -- https://master.php.net/note/delete/120247/spam Del: non-english -- https://master.php.net/note/delete/120247/non-english Del: in docs -- https://master.php.net/note/delete/120247/in+docs Del: other reasons-- https://master.php.net/note/delete/120247 Reject -- https://master.php.net/note/reject/120247 Search -- https://master.php.net/manage/user-notes.php