Search first_name + last_name from one input tag

Add another "full_name" column ? :)

use where input like concat('firstname','lastname')

$models = YourModel::whereRaw('concat(\'first_name\', \'last_name\')', 'LIKE', '%' . $input . '%');

@rhungund I suggest something a bit longer than guys above. And you need a separator in the concat and obviously no quotation marks ' @pmall @Limweb:

select concat('first', 'last');
// 'firstlast'

select concat('first', ' ', 'last');
// or
select concat_ws(' ', 'first', 'last');
// 'first last'

The above of course assuming MySQL, but it's pretty similar in other servers.

Anyway, here's what I suggest:

Model::whereRaw("concat(first_name, ' ', last_name) like '%?%'", [$nameFromInput])
          ->orWhereRaw("concat(last_name, ' ', first_name) like '%?%'", [$nameFromInput])
          ->get();

thanks for the reply every one :)

I'm retrieving data like this..

foreach ($columns as $column) { 
    $query->orWhere($column, 'LIKE', '%' . $value . '%'); 
} 

where $column is table_name.column_name ex: employees.first_name, employee.last_name, projects.project_name, so on..

then how can i use concat(first_name, ' ', last_name) like '%?%'

@rhungund Just the same:

->orWhereRaw("concat(first_name, ' ', last_name) like '%?%' ");

And take my advice and wrap all your orWheres in parentheses, like this:

$query->where(function ($q) use ($columns, $value) {
  foreach ($columns as $column) {
    $q->orWhere($column, 'like', "%{$value}%");
  }
});

Otherwise any and where clause and your whole query is messed up (SoftDelete scope being one for example).

And for your concat, this is what you need exactly:

$columns = ['col1', 'col2', ..., DB::raw("concat(first_name, ' ', last_name)")];

//search by first or last name
Model::where('first_name', 'LIKE', '%$input%')->orWhere(('last_name', 'LIKE', '%$input%')->get();

// create a method to concatenate the result and show it in the view - this will probably be a view presenter.
public function fullName($firstName, $lastname)
{
    return $this->firstName + ' ' + $this->lastName;
}

Hi @JarekTkaczyk

I have tried your solution for searching two first name and last name as one field full time.

Here is my code:

$customers = Customer::orderByRaw("concat(first_name, ' ', last_name)") ->whereRaw("concat(first_name, ' ', last_name) LIKE '%?%'", [$search]) ->orWhereRaw("concat(last_name, ' ', first_name) LIKE '%?%'", [$search]) ->orWhere('email', 'LIKE', '%' . $search . '%') ->orWhere('phone_number', 'LIKE', '%' . $search . '%') ->orWhere('address', 'LIKE', '%' . $search . '%') ->paginate(5);

Any suggestions ?

Thanks in advance.

@alexmansour Do you have any problem with that query? Not sure what I should suggest :)

Hi @JarekTkaczyk thanks for your reply. Actually the query is not working well, no result returned.

The following is the query log for it: http://www.codesend.com/view/701c69544f3749152ece4d0cea6654b0/

Thanks for the info.

I went with:

->orWhereRaw("concat(first_name, ' ', last_name) like '%?%' ");