Add Regexp to sqlite

this code allows sqlite to use regexp just like mysql
ulearnpro · Nov 6, 2019 · f450317 · f450317
1 parent ed057fd
commit f450317
Showing 1 changed file with 6 additions and 0 deletions.
diff --git a/app/Providers/AppServiceProvider.php b/app/Providers/AppServiceProvider.php
@@ -24,5 +24,11 @@ public function register()
     public function boot()
     {
         //
+        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;
+            });
+        }
     }
 }