title: Adding a number to a search to display correct result in php/laravel
body: <p>I have created a simple search function that works by searching my required fields to match my keywords. This works fine for every column apart from my "Id" column, because when I display my ID in the table I actually add + 500 and some text. This is basically because the ID column is my booking/order reference and I didn't want to start at 0 and felt it easier to just offset the displayed result.</p>
  
  <p>Basically I need it to add 500 to the search if when checking against the request_id column. So for the first record in the table would be 1 + 500 + my prefix which displays as SP-501. It I search for 501, it actually brings up record 501 in the table and not the correct one.</p>
  
  <p>Heres my code:</p>
  
  <pre><code>public function search()
  {
  
      $search = \Request::get('search'); 
  
      $bookings = LcsBooking::where('request_email','like','%'.$search.'%')
          -&gt;orWhere('request_id', 'like', '%'.$search.'%')
          -&gt;orWhere('request_name', 'like', '%'.$search.'%')
          -&gt;orWhere('request_arrival', 'like', '%'.$search.'%')
          -&gt;orWhere('request_return', 'like', '%'.$search.'%')
          -&gt;orWhere('request_txauthno', 'like', '%'.$search.'%')
          -&gt;orWhere('request_vehicle_reg', 'like', '%'.$search.'%')
          -&gt;orWhere('request_mobile', 'like', '%'.$search.'%')
          -&gt;orderBy('request_id', 'DESC')
          -&gt;paginate(20);
  
      return view('admin.lcs.search',compact('bookings'));
  }
  </code></pre>