Func odbc SQL query

Asterisk Asterisk Support
1

Hello everyone,

I want to achieve this query

select id from users where number like ‘%657356353%’ or number like ‘%,657356353,%’ or number like ‘%,657356353’ or number like ‘657356353,%’

So I wrote the query in func_odbc like this

SELECT id from users where number like ‘%’${ARG2}’%’ or number like ‘%,’${ARG2}’,%’ or number like ‘%,’${ARG2}’’ or number like ‘’${ARG2}’,%’

But I am getting errors.

2

What errors are you getting?

3

It is not getting the id

4

I think I did it wrong it should have been written like this

SELECT id from users where number like ‘%${ARG2}%’ or number like ‘%,${ARG2},%’ or number like ‘%,${ARG2}’ or number like ‘${ARG2},%’ ) LIMIT 1