Hi all,
i have 2 collections :
-
users
{ _id: 1, username: ‘mark’ },
{ _id: 2, username: ‘leon’ },
{ _id: 3, username: ‘leontin’ }, -
data
{
_id: ObjectId(‘6675309f82bdfbe3b00febfa’),
user: 1,
message: ‘94451 Laos Sweden Iran’,
}
{
_id: ObjectId(‘6675309f82bdfbe3b00febfa’),
user: 2,
message: ‘message 22222’,
},
{
_id: ObjectId(‘6675309f82bdfbe3b00febfa’),
user: 3,
message: ‘message 3333’,
}
if i search :
$results = $collectiondata->aggregate([[‘$lookup’ => [“from” =>“users”, “localField” => “user”, “foreignField” => “_id”, “as” => “user_info”]], [‘$match’ => [‘user_info.username’ => ‘leontin’]]])->toArray();
is working good.
But i need to get all result where username like ‘^leo’ .
Any help, thx in advance.
Regards I.