30 Apr
2019
30 Apr
'19
11:58 a.m.
Hello, It's not working... allocate-find = "SELECT ip_address FROM radippool WHERE (pool_name like '%{reply:Pool-Suffix}*%%' and pool_name not like '%%STATx%%') AND expiry_time < NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE" [IP-POOLING-01] expand: SELECT ip_address FROM radippool WHERE (pool_name like '%{reply:Pool-Suffix}*%' and pool_name not like '%STATx%') AND expiry_time < NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE -> SELECT ip_address FROM radippool WHERE (pool_name like 'BC*%' and pool_name not like '2019-04-30 17:55:08TATx%') AND expiry_time < NOW() ORDER BY rand(), pool_name, expiry_time LIMIT 1 FOR UPDATE What I'm doing wrong?