Ignore special characters before match conditions

Question

How can I write equivalent of following in mongo? I need to ignore some characters(spaces, hyphen) from a particular column before conditions are checked. For the sake of putting an example of mysql I am just removing space.

select * from TABLE
where REPLACE('name', ' ', '') = 'TEST'

So if name column has " T E S T" that should match.

Answer 1

You can try with $where operator in your query:

{$where: "this.name.replace(/[ -]/g,'') == 'TEST'"}

or:

{$where: "this.name.match(/T[ -]*E[ -]*S[ -]*T/)"}

or directly a $regex:

{name: /T[ -]*E[ -]*S[ -]*T/}

More info about $where $regex operators.