laravel框架where查询json格式的数据

Question

laravel框架where查询json格式的数据

Answer 1

public function store(Request $request)
{
$this->validate($request, [
'title' => 'required|unique:posts|max:255',
'body' => 'required',
]);

// The blog post is valid, store in database...
}

Answer 2

$query->whereRaw("JSON_CONTAINS(group_id,'[\"$id\"]')")->get();