You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Qualifying the _ wildcard in a filter

Question
10
Views
0
Comments

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: [email protected] would need to be a\[email protected]

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!