Hi @Jon_C,
You can use regular expressions in your filter criteria within Compass. Regular expressions provide a superset of SQL’s LIKE functionality with more advanced pattern matching options similar to REGEXP functions in SQL.
For example: {myfield:/pattern/} would perform a case-sensitive substring match for the given pattern.
I would draw your attention to the Index Use information on regular expressions, as many regular expression queries cannot use indexes effectively.
Some useful references that may make your SQL experience more relatable:
Regards,
Stennie