mysql - Laravel Eloquent - 多个 NOT LIKE 查询？

Question

我有一个来自数据库的可变输出，如下所示:

1,2,3,4，有时5,4,9

我想根据用户添加 not like where 子句:

例如:

用户 1

$products = \App\Product::where('user', '1')
    ->where(['category', 'not like', '1,2,3,4')
    ->get();

用户2

$products = \App\Product::where('user', '2')
    ->where(['category', 'not like', '5,4,9')
    ->get();

Answer 1

https://laravel.com/docs/5.8/queries#where-clauses

$products = \App\Product::where('user','2')
  ->whereNotIn('category', [5, 4, 9])
  ->get();