laravel where like query on array column with array data

Question

here is my database data design title description skills[]

and request data is tags array which I wanna check with database skills if tags like database skills then return all jobs

$companyTags = CompanyJobTag::where('company_id', $company->id)->get();
$query = EmployerJob::with('user');

$tags = [];
foreach ($companyTags as $key => $tag) {
      array_push($tags, $tag->tag);
}

$query->where(function($q) use($tags){
        for ($i=0; $i < count($tags); $i++) { 
            $q->orWhere('title', 'LIKE', "%{$tags[$i]}%");
        }
});
$jobs = $query->orderByDesc('created_at')
    ->paginate(10);
        
    return response()->json($jobs, 200);

here I can check employer job with companytags array, but empoyerjob also contains jobs skills array so how I can get only that jobs which match with company tags array

We need to know a little more about the structure of your database. How is link in your database the "employer job" and "compagny" ? — Ondrelat
– Ondrelat, Commented Mar 6, 2022 at 8:54
employer_jobs table have user_id which user have posted his job, and employee_jobs have title, description and his skills array as shown in the screenshot, and company have company_skills table which have company_id and skill name now I wanna show employers job which skills like with company_tags — HBilal Khan
– HBilal Khan, Commented Mar 6, 2022 at 8:58
To search in array do you try something like say in this stackoverflow.com/questions/38159729/… ? — Ondrelat
– Ondrelat, Commented Mar 6, 2022 at 10:11
yes I try that, but i dont want to get the exact match I want something which do by LIKE — HBilal Khan
– HBilal Khan, Commented Mar 6, 2022 at 10:20
So i think this is the response stackoverflow.com/questions/34329886/… — Ondrelat
– Ondrelat, Commented Mar 6, 2022 at 10:24

shafi M · Accepted Answer · 2022-03-06 09:34:31Z

0

$companyTags = CompanyJobTag::where('company_id', $company->id)->pluck('name'); //select tags column
$query = EmployerJob::whereJsonContains('skills',$companyTags)->with('user');

answered Mar 6, 2022 at 9:34

shafi M

243 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

HBilal Khan Over a year ago

hello bro! this solutions only return the exact match is it possible to use LIKE query here?

shafi M Over a year ago

use whereJsonContains('skills','like',$companyTags)

shafi M Over a year ago

actually, I didn't test it

Collectives™ on Stack Overflow

laravel where like query on array column with array data

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related