How to generate a query with a regular expression in Yii2?

Question

Yii

I use Yii2 + Yii2-mongodb
A query similar to sql is required: name LIKE "%text%"
As I understand it, in Mongo this is only regular expressions, so I write:

$q = [
  'name' => [
    '$regex' => $text,
    '$options' => 'i',
  ]
];
$result['mobs'] = Biotype::find($q)->limit(10)->all();

according to https://docs.mongodb.com/manual/reference/operator...
Tried

$q = ['name' => new \MongoDB\BSON\Regex('*('.trim($text).')*', 'ig')];
$result['mobs'] = Biotype::find($q)->limit(10)->all();

In both cases, I get the same result - the first 10 records without any filtering, just like if I send an empty condition at all. CHADNT?

Answer 1

i blunted.

$q = [
  'name' => [
    '$regex' => $text,
    '$options' => 'i',
  ]
];
$result['mobs'] = Biotype::find()->where($q)->limit(10)->all();