How to support $not operator with regex?

[joe2tw]

db.inventory.find( { item: { $not: /^p.*/ } } )

How can I do this query in laravel-mongodb?

Thanks.

[jenssegers]

Use where('item', 'not regexp', '...'), it's the same as Laravel.

[joe2tw]

Hi jenssegers,

Thank you for your reply.

I got an error message:

MongoCursorException (17287)
localhost:27017: Can't canonicalize query: BadValue unknown operator: $not regexp'

Whether I tried

$inventories = Inventory::where('item', 'not regexp', "/^p./")->take(10)->get();

or

$inventories = Inventory::where('item', 'not regexp', new MongoRegex("/^p./"))->take(10)->get();


---

This works fine:

$inventories = Inventory::where('ip', 'regexp', new MongoRegex("/^p.*/"))->take(10)->get();


[jenssegers]

Check out that last commit, it fixes your problem. It will also automatically convert your regular expressions to MongoRegex objects. This will work now:

$inventories = Inventory::where('item', 'not regexp', "/^p./")->take(10)->get();

[vijay-dhokrat]

Hi @jenssegers what will be the max limit for ->take(10)
I want all data for regex

[psanjib]

Hi @jenssegers i have wriiten a simple query it's not working

$comments = new Comment;
$query = $comments::where('title', 'REGEXP', '8183|81600')->get();

It returns all record. It should return only 2 record. i have tested by writing Sql Query
Raw Sql query - SELECT * FROM Test where title REGEXP '8183|81600'; It is working fine.

Please find the attached image, records available in the DB.