title: Laravel - select temporary column where temporary column
body: <pre><code>$search_str = "full name search";
  
  $user = App\User::selectRaw("CONCAT(`f_name`, `l_name`) AS `fullname`")
          -&gt;where('fullname', 'LIKE', '%$search_str%')
          -&gt;get();
  </code></pre>
  
  <p>Based on the code above, the column <code>fullname</code> actually does not exist in DB Table. <code>fullname</code> column is just a temporary column.</p>
  
  <p>But when I use it on <code>where</code> clause, Laravel return an error:</p>
  
  <blockquote>
    <p>Column not found: 1054 Unknown column 'fullname' in 'where clause' </p>
  </blockquote>