Fetching Multiple Rows from MySQL

As a new member, i would like to know if there is a way to retrieve multiple rows from mysql in my dialplan and store the results in arrays.

Here have an example.
https://community.asterisk.org/t/fetch-did-from-my-mysql-db/78562/3

I always prefer to use func_odbc to connect with databases and here’s one really good example to fetch multiple rows from DB.
Search for " Multirow Functionality with func_odbc" on this page