title: Laravel select with multiple where in statement
body: <p>I have tried various methods to resolve this issue, but none worked for me. </p>
  
  <p><strong>1st method</strong>:</p>
  
  <pre><code>$title = Character::find($selected_char-&gt;id)-&gt;title()-&gt;where('title', '=', 'Castle'); 
  $title = $title-&gt;where('title', '=', 'City');
  $title = $title-&gt;get();
  </code></pre>
  
  <p><strong>2nd method</strong>:</p>
  
  <pre><code>$title = Character::find($selected_char-&gt;id)-&gt;title()-&gt;where('title', '=', 'Castle')-&gt;where('title', '=', 'City')-&gt;get();
  </code></pre>
  
  <p><strong>3rd method</strong>:</p>
  
  <pre><code>$title = DB::select(DB::raw("select * from titles where titles.char_id = 5 and title = 'Castle' and title = 'City'"));
  </code></pre>
  
  <p>None of the above methods work. If I take only one where clause it works perfectly. Example:</p>
  
  <pre><code>$title = Character::find($selected_char-&gt;id)-&gt;title()-&gt;where('title', '=', 'City')-&gt;get();
  
  $title = Character::find($selected_char-&gt;id)-&gt;title()-&gt;where('title', '=', 'Castle')-&gt;get();
  </code></pre>
  
  <p>I even tried to take another column than title, but it doesn't work with a second where function. I want to retreive the rows from titles table where the title is City AND Castle I have used multiple where clauses before in a single select statement and it worked. Not now. Any suggestions? Thanks in advance.</p>