@@ 318-322 (lines=5) @@ | ||
315 | protected function caseInsensitiveColumnSearch($i, $column, $keyword) |
|
316 | { |
|
317 | if ($this->request->isRegex($i)) { |
|
318 | if ($this->isOracleSql()) { |
|
319 | $this->query->whereRaw('REGEXP_LIKE( LOWER(' . $column . ') , ?, \'i\' )', [$keyword]); |
|
320 | } else { |
|
321 | $this->query->whereRaw('LOWER(' . $column . ') REGEXP ?', [Str::lower($keyword)]); |
|
322 | } |
|
323 | } else { |
|
324 | $this->query->whereRaw('LOWER(' . $column . ') LIKE ?', [Str::lower($keyword)]); |
|
325 | } |
|
@@ 338-342 (lines=5) @@ | ||
335 | protected function caseSensitiveColumnSearch($i, $column, $keyword) |
|
336 | { |
|
337 | if ($this->request->isRegex($i)) { |
|
338 | if ($this->isOracleSql()) { |
|
339 | $this->query->whereRaw('REGEXP_LIKE( ' . $column . ' , ? )', [$keyword]); |
|
340 | } else { |
|
341 | $this->query->whereRaw($column . ' REGEXP ?', [$keyword]); |
|
342 | } |
|
343 | } else { |
|
344 | $this->query->whereRaw($column . ' LIKE ?', [$keyword]); |
|
345 | } |