Laravel eloquent multiple WHERE with OR AND OR and LIKE? : <p>I have ( or am trying to make ) this query in Laravel</p>

<p>The problem I have is with the <code>$orThose</code><br>
I want to query <code>LIKE</code>.  </p>

<p>The data in that field can be many things, but there will always be a key work like "L3" or "ICU" in the field.</p>

<p>Can you do a <code>LIKE</code> query in this case</p>

<pre><code>$matchThese = ['link.hos_id' =&gt; $hos_id, 'outcome.otc_otrdischargedate' =&gt; $td];
$orThose = ['outcome.otc_outcome' =&gt; '@ICU@', 'outcome.otc_outcome' =&gt; '@I.C.U@'];

$todaysReferrals = DB::table('link')
-&gt;join('daily_link', 'link.lnk_id', '=', 'daily_link.dlk_lnkid')
-&gt;join('demographic', 'link.lnk_dmgid', '=', 'demographic.dmg_id')
-&gt;join('admission', 'link.lnk_admid', '=', 'admission.adm_id')
-&gt;join('or_call', 'admission.adm_calid', '=', 'or_call.cal_id')
-&gt;join('admission_score', 'admission.adm_scoreid', '=', 'admission_score.ascore_id')
-&gt;join('diagnosis', 'link.lnk_dgnid', '=', 'diagnosis.dgn_id')
-&gt;join('outcome', 'link.lnk_otcid', '=', 'outcome.otc_id')
-&gt;where($matchThese)
-&gt;orWhere($orThose)
-&gt;get();
</code></pre>
