# JDBC Limit equivalent? **URL:** \ **Category:** Logstash\ **Created:** [November 27, 2021, 9:01pm UTC](https://discuss.elastic.co/t/jdbc-limit-equivalent/290346 "2021-11-27T21:01:47Z")\ **Posts on this page:** 1\ **Showing post:** 3
**Author:** ![rojin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rojin/32/97697_2.png) [@rojin](https://discuss.elastic.co/u/rojin)\ **Post date:** [November 28, 2021, 5:44am UTC](https://discuss.elastic.co/t/jdbc-limit-equivalent/290346/3 "2021-11-28T05:44:59Z")
None of them worked for my query. > [@JDBC - SQL Query Issue](https://discuss.elastic.co/t/jdbc-sql-query-issue/290345): > > Hi! I have a database in MySQL and I want to fetch some info based on IP addresses I get from my client logs. There are ip\_from(VARCHAR 50), ip\_to(VARCHAR 50), ip\_from\_int(INT 10), and ip\_to\_int(INT 10) plus a name(VARCHAR 255) column in my desired table. I have written the filter as below and I want to fetch the name if the IP address is between ip\_from and ip\_to. But it keeps telling me that it cannot recognize INET\_ATON as a function in JDBC. Is there a way I can get my result? the "clientip"… --- _[View the full topic](https://discuss.elastic.co/t/jdbc-limit-equivalent/290346)._