Ali Alsuliman the first part of the issue is down to the fix to
MB-19230 not being complete: we should test for
% as well as % as matching string ending, and not add $ in the case of
The second part stems from using regexp to simulate like, and the particular implementation of regexp, which is line rather than string based - this will always be cause of false positives, and we should probably write our own like matching code.
Currently, I cannot undo the ?m because I would break another query, so we'll have to think about something else.