===
digits is the column that contains the list of numbers to match to

tblnm is a column that specifies a group of entries that make up a "route table" form the telephone company's standpoint.

6022241234 as an example I plugged in and used for testing, in the app we use whatever the user dials
it works but it takes close to 1/2 second to execute which in the telephony world is wholey unacceptable
====

If the digits col is used for storing the telephone number, then REVERSE KEY INDEX will help to retrive the row fast. When the user enters full digits for a telephone number, then this will work. I just give an option. The original poster concerns about performance. 0.5 second is not acceptable.

I know we cannot use LIKE operator with the REVERSE KEY INDEX.

Tamil