Skip to content

Instantly share code, notes, and snippets.

@saitergun

saitergun/laravel-sqlite-regexp.php

Created July 5, 2021 15:33
Show Gist options
  • Save saitergun/2216415e52f16efd6f90033b83da58fd to your computer and use it in GitHub Desktop.
Save saitergun/2216415e52f16efd6f90033b83da58fd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
laravel-sqlite-regexp.php
DB::connection()->getPdo()->sqliteCreateFunction('REGEXP', 'preg_match', 2);
DB::table('tablename')->whereRaw('lower(tablecolumn) REGEXP "'.$regex.'"');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment