Level 54
try reformatting please. add your three backticks on a new line and then your code underneath it.
1 like
Jul 22, 2021
6
Level 1
Where Not Like not functioning laravel DB Eloquent.
```
$data->where(function ($query) {
$query->where('sample1', 'not LIKE', '%not%')
->orWhere('sample2', 'not LIKE', '%not%');
});
```
Level 1
dont know how tried to search but failed.
Level 1
done. Thank you.
Level 73
Use the preview slider to make sure the code is readable before submitting.
$data->where(function ($query) { $query->where('sample1', 'not LIKE', '%not%') ->orWhere('sample2', 'not LIKE', '%not%');
});
Level 54
@elgetenz so what's not working with
$data->where(function ($query) {
$query->where('sample1', 'not LIKE', '%not%')
->orWhere('sample2', 'not LIKE', '%not%');
});
?
show your failing test
1 like
Level 8
@elgetenz I know this is an old post so for the benefit for others, if using MySQL and the field is null, then the NOT LIKE operator won't work. So maybe try...:
$data->where(function ($query) {
$query->where('sample1', 'not LIKE', '%not%')
->orWhere('sample2', 'not LIKE', '%not%')
->orWhereNull('sample1')
->orWhereNull('sample2');
});
Please or to participate in this conversation.