Qualifying the _ wildcard in a filter
Content
Our contact quick search fails due to the number of rows examined when we search for an email address that has a _ (underscore) in the 2nd position. Turns out MySQL sees that as a wildcard and we need to qualify it with a \
Example: a_test@test.com would need to be a\_test@test.com
We can't ask our agents to remember that whenever they come across one of these emails. So, is there a way to massage the report filter prior to searching, maybe using variables or complex expressions?
I'm picturing something like this, but in a filter.
Tagged:
0