要在单个查询中执行此操作，必须向查询结果中添加一个新列，以指示在何处找到搜索结果。
这可以通过使用sql case来实现。以下是一般示例：

$select  = "*, CASE";
$select .= " WHEN (title LIKE '%".$search."%' and description LIKE '%".$search."%') THEN 'title-description'";
$select .= " WHEN (title LIKE '%".$search."%') THEN 'title'";
$select .= " WHEN (description LIKE '%".$search."%') THEN 'description'";
$select .= " END as FoundIn";

Model::selectRaw($select)->where('title','LIKE','%'.$search.'%')->orWhere('description','LIKE','%'.$search.'%')->get();

这将在结果中添加一个名为“foundin”的新列，指示在何处找到搜索结果。
示例：

$search = "Dummy";
$select  = "*, CASE";
$select .= " WHEN (topic LIKE '%".$search."%' and subject LIKE '%".$search."%') THEN 'topic-subject'";
$select .= " WHEN (topic LIKE '%".$search."%') THEN 'topic'";
$select .= " WHEN (subject LIKE '%".$search."%') THEN 'subject'";
$select .= " END as FoundIn";

Message::selectRaw($select)->where('topic','LIKE','%'.$search.'%')->orWhere('subject','LIKE','%'.$search.'%')->get();

结果：

Illuminate\Database\Eloquent\Collection {#2929
    all: [
    App\Message {#2947
        id: 3,
        topic: "Dummy Title",
        subject: "Dummy Description",
        created_at: null,
        updated_at: null,
        FoundIn: "topic-subject",
    },
    App\Message {#2940
        id: 4,
        topic: "Dummy Title",
        subject: "Smart Description",
        created_at: null,
        updated_at: null,
        FoundIn: "topic",
    },
    App\Message {#2941
        id: 5,
        topic: "Smart Title",
        subject: "Dummy Description",
        created_at: null,
        updated_at: null,
        FoundIn: "subject",
    },
    ],
}

您可以执行两个查询而不是一个查询：

$fromTitle = Model::where('title','LIKE','%'.$search.'%')->get();
$fromDesc = Model::where('description','LIKE','%'.$search.'%')->get();

return ['title'=>$fromTitle, 'description'=>$fromDesc];

也许您需要将$search变量与从elokent获得的title和description属性进行比较？

$collection = Model::where('title','LIKE','%'.$search.'%')
            ->OrWhere('description','LIKE','%'.$search.'%')->get();
$isDescription = $collection->description === $search;

我不确定这是不是最好的解决办法。