How to do it…

If we wanted to use a MySQL query to search for the caller name for an incoming caller ID, we must enter the Host, the Database, the Username, the Password, and the Query that will be executed to search for the name. Cache results options are checked in the image. This will allow the system to store results astDB in the cache, so that the system can perform lookups locally instead of remote lookups. This is shown in the next image:

The database query would be as follows: select name from users with an extension like %[NUMBER]%. This will search in the database for the name of the caller associated with the number in the table called users.