title: Laravel Scout search by multiple columns
body: <p>I have a user model with the following fields:</p>
  <pre><code>protected $fillable = [
      'name',
      'email',
      'password',
      'birthday',
      'surname'
  ];
  </code></pre>
  <p>I created a search bar to search the users. I'm using Laravel scout to query the users like this:</p>
  <pre><code>$matchingUsers = User::search($request-&gt;search)-&gt;get();
  </code></pre>
  <p>If I search with just the name or just the surname, the result is fine. The problem is when introducing the name and the surname. In this case, I get no results.</p>
  <p><strong>Expected result</strong></p>
  <p>Given the following records in my database:</p>
  <p>-[id=&gt;1 , name =&gt; &quot;Neil&quot;, surname =&gt; &quot;Armstrong&quot;]
  -[id=&gt;2 , name =&gt; &quot;Juan Manuel&quot;, surname = &quot;Armstrong&quot;]</p>
  <ol>
  <li><p>If I introduce &quot;Neil Armstrong&quot; I expect to get the user with id = 1.</p>
  </li>
  <li><p>If I search for &quot;Juan Armstrong&quot;, I expect to get user with id = 2.</p>
  </li>
  <li><p>If I search for &quot;Manuel&quot;, I expect to get the user with id = 2.</p>
  </li>
  </ol>
  <p><strong>What I have tried so far</strong></p>
  <p>Using raw SQL directly querying in the database manager I got the expected result for situation 1 using the following query:</p>
  <pre><code>SELECT id, name, surname, image
  FROM users
  WHERE CONCAT(name,' ', surname) = &quot;Neil Armstrong&quot;;
  </code></pre>
  <p>For the other two cases, I've tried to use the orWhere() method. However, this doesn't seem to work together, and anyway mixing raw SQL with eloquent and Scout seems so dirty.</p>
  <p>Is there any way to use Laravel Scout to do something like this? A solution using just Eloquent wold also be useful.</p>