MySQL CallerID Query

General Help
1

Hi, I am seeking advice the module of “CallerID Look Up Sources”, using MySQL.

I have a MySQL database titled “callerid”. In this database, it has a table called “work”. The table “work” has 2 variables: “number” and “name”. The primary variable is “number”.

In the FreePBX “CallerID Look Up Sources” model, I did this:

Source: MySQL
host: localhost
Database: callerid
Query: SELECT name FROM work WHERE number LIKE '%[NUMBER]%'
User Name: root
Password: …

But, it did not work. Where did I do wrong?

Thanks in advance.