How to use like query after with clause

If there are two table student and course , Now if i want to use like query in course after relation with student. eg Student::where(id,5)->with("havecourse")->where('course_name','LIKE','%'.'BC','%')->get()

How to do that thanks.

gmann1982

8 years ago

Level 4

Not quite 100% sure but i think you are looking for something like this:

$students= Student::where('id', 5)
    ->whereHas('havecourse', function ($query) {
        $query->where('course_name', 'like', '%BC%');
    })->get()

mithilesh999

8 years ago

Level 1

assume $var ="BC" and i have to use it like $students= Student::where('id', 5) ->whereHas('havecourse', function ($query) { $query->where('course_name', 'like', '%'.$var.'%'); })->get()

1 like

mithilesh999

8 years ago

Level 1

I got solution after some digging $var = "BC"; $students= Student::where('id', 5) ->whereHas('havecourse', function ($query) use($var) { $query->where('course_name', 'like', '%'.$var.'%'); })->get();

Please or to participate in this conversation.