Regular expression in mongoDB

Summary:

Content (please ensure you mask any confidential information):

Hello,

We would like to have a regular expression in mongoDB.

We now have:

SHELF_TYPE :{$regex:"|****_ShelfType|"}

But we would like to concatenate them a prefix and a postfix to the regular expression.

For example if ****_ShelfType has value "prova", we would like to extract from the table only the elements that have [PROVA] and not [PROVA_1].

Is there a way to do it?

Thank you,

Silvia

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):