.png){kind=logo}
Check Users' Presence in MySQL Database Efficiently
Is there a way to check a list of users whether they are in my mysql database?
While we don't have direct MySQL integration, you can use our PostgreSQL integration to check if rows exist in your database. Here's how you can do it: 1. Use the "Lookup Row in PostgreSQL" action with the following setup: • Write a SELECT query to check for your users • Provide your database host IP address (note: localhost won't work) • Specify the port number • Enter your database name • Optionally include the schema nameThe action will efficiently verify data presence using EXISTS subquery functionality without retrieving entire rows. Sources: Postgres integration overview | Documentation | Clay University Lookup Row with Postgres
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.