I'm pretty sure the stuff you need for mod_sofia is found here:
http://wiki.freeswitch.org/wiki/Using_ODBC_in_the_core

However, I'm not sure what exactly you mean about the query in the dialplan. Could you clarify what you mean?
-MC

On Sun, May 27, 2012 at 2:18 AM, Samira Mh <saami_mh@ymail.com> wrote:
hi guys,
i have created mysql database name "x" using ODBC in freeswitch,
now i have the table named "y" in  the "x" databases;
now,how can i connect the sipuser in my direcroty to the "x" database so that use the result of quert for taht user?
and how can i insert query into the dialplan to connect myuser to mysql table
how can i do that ?
thanks alot