title: SQL column not found in laravel
body: <p>i am trying to apply whereRaw method on a laravel collection</p>
  <pre><code>return Auth::user()-&gt;friends()-&gt;whereRaw('CONCAT(friend.first_name,&quot; &quot;,friend.last_name) LIKE \''.$fullName.'%\'')-&gt;get();
  </code></pre>
  <p>i am getting this error :</p>
  <blockquote>
  <p>message: &quot;SQLSTATE[42S22]: Column not found: 1054 Unknown column 'friend.first_name' in 'where clause' (SQL: select * from <code>friends</code> where (<code>friends</code>.<code>user_id</code> = 46 and <code>friends</code>.<code>user_id</code> is not null or <code>friend_id</code> = 46 and CONCAT(friend.first_name,&quot; &quot;,friend.last_name) LIKE 'ffff%') and <code>friends</code>.<code>deleted_at</code> is null)&quot;</p>
  </blockquote>
  <p>menawhile the columns first_name and last_name already exists</p>