The CONTAINS operation is equivalent to "LIKE '%value%'" in mysql

Although there is one difference and that is the default setup in mysql is that the LIKE is case-insensitive.

So the question is should CONTAINS in mongodb also be case-insensitive?

This change could be achieved with the attached patch.

CommentFileSizeAuthor
mongodb_contains_case_insensitive.patch838 bytesunivate

Comments

univate’s picture

univate commented
Status: Active » Needs review

Status: Needs review » Needs work

The last submitted patch, mongodb_contains_case_insensitive.patch, failed testing.

misc’s picture

misc commented
Status: Needs work » Patch (to be ported)
misc’s picture

misc commented
Status: Patch (to be ported) » Closed (fixed)

Patch was applied to 7.x-1.x

misc’s picture

misc commented
Status: Closed (fixed) » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.