title: How can I "where" raw column(DB::raw). [LARAVEL]
body: <p><strong>My Objective</strong> for these, is to make an autocomplete input text for location. When I type something like 'streetNo', 'city' or 'country' relevant data should return<br><br>
  I just created a raw column "full_address" joining "streetNo", "city", &amp; "country" column.<br>
  <br>
  <strong>Heres my code:</strong><br></p>
  
  <pre><code>$searchAddress = $r-&gt;input('address'); //dynamic
  
  $profile = DB::table('student')
      -&gt;select(
          'students.id',
          'students.name',
          'students.class',
          'students.schedule',
          'inf.streetNo',
          'inf.city',
          'inf.country',
          DB::raw("(CONCAT(inf.streetNo,' ',inf.city,' ',inf.country)) AS full_address")
      )
      -&gt;where('full_address', 'LIKE', "%{$searchAddress}%")
      -&gt;join('informations AS inf', 'inf.student_id', 'students.id')
      -&gt;get();
  </code></pre>
  
  <p><strong>I tried</strong> to search existing data like "city or country" but no data returned. I suspect there something wrong of "where-ing" the data. <br>
  <br>
  <strong>Question is</strong> can we "where" temporary column like "full_address column" like the code shown above?? Because I tried that code and no data returned when there is actually<br>
  <br>
  Need your help, Sirs..</p>