Laravel: SQLite REGEXP

laravel:sqlite_regexp.php

// create the function
DB::connection()->pdo->sqliteCreateFunction("REGEXP", "preg_match", 2);

// build a query
DB::table('tablename')->raw_where('REGEXP("#^[a-z]+$#iu", tablename.row)')->get();

I had to remove the delimiter to make this work. I use this code in my AppServiceProvider.

if (DB::Connection() instanceof \Illuminate\Database\SQLiteConnection) {
    DB::connection()->getPdo()->sqliteCreateFunction('REGEXP', function ($pattern, $value) {
        mb_regex_encoding('UTF-8');
        return (false !== mb_ereg($pattern, $value)) ? 1 : 0;
    });
}

Thanks! Works perfectly!