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 UniversityLookup 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.
.png){kind=logo}
