How to compare input variable with value in MySQL database?

Question

MySQL

Hello! Please tell me how to compare the entered variable with the value in the MariaDB database?
The database can contain up to 10 unique combinations.
When calling an external number, the system asks to enter the code:
exten => trunk,1,Background(enter-secure)
We enter the code:
same => n,Read(enter-digits,,8)
Enter the entered value into the table:
same => n(check),Set(ODBC_ENTER_DIGITS(${CALLERID(num)},${enter-digits})="")
And now the question arises, how to compare two values ​​- entered and one of the ten available ?

Answer 1

And what for to enter entered value in base? You need to describe a query function in func_odbc.conf that returns the presence of a specified value in the database, for example, via COUNT (), and call this function in Asterisk and check the value returned to it.