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();