CODE EXAMPLE FOR PHP

sql - Laravel concat in query (where condition)

$query->orWhereRaw("CONCAT(`nvp`, ' ', `vpv`) LIKE ?", ['%'.$this->searchNeedle.'%']);