search for phone number in ph_mobile with our without leading 0
Content
Hi,
Currently we have the challenge to find a mobile phone number, that is maintained sometimes with and sometimes without leading 0 (yes I know, that should not be!).
However, I am considering if there could be a kind of logic for a quick search that could bypass the issue of index search without exact search string. Means, if I search with an equal filter, the index is used and I get an immediate response. If I use a like, search is potentially done deferred, which is no solution for an agent.
Is there potentially any complex expression filter possible, that searches exactly, but with both options (so either leading 0 or not) and still meets the index on that field?
Tagged:
0