试试这个 :
$array = ['web design', 'accounting'];
$result = DB::table('jobs')
->where(function ($query) use($array) {
foreach($array as $key) {
$query->orWhere('skillsetNeeded', 'LIKE', "%$key%")
}
})
->get();
Laravel Eloquent中的多个LIKE子句
试试这个 :
$array = ['web design', 'accounting'];
$result = DB::table('jobs')
->where(function ($query) use($array) {
foreach($array as $key) {
$query->orWhere('skillsetNeeded', 'LIKE', "%$key%")
}
})
->get();