yajra / laravel-datatables

    protected function regexColumnSearch($column, $keyword)

    {

        switch ($this->connection->getDriverName()) {

            case 'oracle':

                $sql = !$this->isCaseInsensitive() ? 'REGEXP_LIKE( ' . $column . ' , ? )' : 'REGEXP_LIKE( LOWER(' . $column . ') , ?, \'i\' )';

                $this->query->whereRaw($sql, [$keyword]);

                break;

            case 'pgsql':

                $sql = !$this->isCaseInsensitive() ? $column . ' ~ ?' : $column . ' ~* ? ';

                $this->query->whereRaw($sql, [$keyword]);

                break;

            case 'pgsql':

                $sql = !$this->isCaseInsensitive() ? $column . ' ~ ?' : $column . ' ~* ? ';

                $this->query->whereRaw($sql, [$keyword]);

                break;

            default:

                $sql = !$this->isCaseInsensitive() ? $column . ' REGEXP ?' : 'LOWER(' . $column . ') REGEXP ?';