# MySQL Query Equivalent In JDBC Static

**URL:** <https://discuss.elastic.co/t/mysql-query-equivalent-in-jdbc-static/290347>\
**Category:** Logstash\
**Created:** [November 27, 2021, 9:06pm UTC](https://discuss.elastic.co/t/mysql-query-equivalent-in-jdbc-static/290347 "2021-11-27T21:06:28Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [December 3, 2021, 7:11pm UTC](https://discuss.elastic.co/t/mysql-query-equivalent-in-jdbc-static/290347/3 "2021-12-03T19:11:12Z")

</div>

As noted in [another version](https://discuss.elastic.co/t/query-ok-in-jdbc-stream-but-not-in-jdbc-static/290362) of this question, MySQL supports INET\_ATON, so it can probably be used in the loader, but Derby does not, so it cannot be used in the lookup.

---

_[View the full topic](https://discuss.elastic.co/t/mysql-query-equivalent-in-jdbc-static/290347)._