title: Laravel: Find exact match, case sensitive
body: <p>This code works but it is not sensitive to case/capitalization.</p>
  
  <pre><code>    public function search(){
  
          if ($search = \Request::get('q')) {
              $patrons = Patron::where(function($query) use ($search){
                  $query-&gt;where('barcode','=',"$search")
  
              })-&gt;paginate(20);
          }else{
              $patrons = Patron::latest()-&gt;paginate(5);
          }
  
          return $patrons;
      }
  </code></pre>
  
  <p>Example</p>
  
  <blockquote>
    <p>Searching for 'banana123' should NOT be equal to 'BaNaNa123' and should return 0.</p>
  </blockquote>
  
  <p>How can we make the search exact match? Thank you.</p>