SQL not a variable

[Dom Latter]

On 30/04/2019 16:31, Matthew Newton wrote:
> On Tue, 2019-04-30 at 15:23 +0000, Nicolas Breuer wrote:
>> In the module IP POOL, I'm trying to use the "%" SQL chars.
>> The issue is that the module expand the %S as a variable. (Time)
>> What can I do to avoid that ?
> 
> "%%" expands to "%".


So for example, in this:
WHERE (maclist.value LIKE '%%%{request:Calling-Station-Id}%%'
the outer "%%" gets expanded to a single "%" (sql wildcard)
and then the other one is used to expand the request value.