| @@ 273-277 (lines=5) @@ | ||
| 270 | $column = $this->castColumn($column); |
|
| 271 | if ($this->isCaseInsensitive()) { |
|
| 272 | if ($this->request->isRegex($i)) { |
|
| 273 | if($this->isOracleSql()){ |
|
| 274 | $this->query->whereRaw(' REGEXP_LIKE( LOWER('.$column.') , ?, \'i\' )', [$keyword]); |
|
| 275 | }else{ |
|
| 276 | $this->query->whereRaw('LOWER(' . $column . ') REGEXP ?', [Str::lower($keyword)]); |
|
| 277 | } |
|
| 278 | } else { |
|
| 279 | $this->query->whereRaw('LOWER(' . $column . ') LIKE ?', [Str::lower($keyword)]); |
|
| 280 | } |
|
| @@ 284-288 (lines=5) @@ | ||
| 281 | } else { |
|
| 282 | $col = strstr($column, '(') ? $this->connection->raw($column) : $column; |
|
| 283 | if ($this->request->isRegex($i)) { |
|
| 284 | if($this->isOracleSql()){ |
|
| 285 | $this->query->whereRaw(' REGEXP_LIKE( '.$col.' , ? )', [$keyword]); |
|
| 286 | }else{ |
|
| 287 | $this->query->whereRaw($col . ' REGEXP ?', [$keyword]); |
|
| 288 | } |
|
| 289 | } else { |
|
| 290 | $this->query->whereRaw($col . ' LIKE ?', [$keyword]); |
|
| 291 | } |
|