Question

MYSQL Query? I thinnk that's what I need

I have an MYSQL database connected to Zapier.

It’s my order table

Each order has a order_id

I’d like to only search the last 200 lines

For a specific order for order_status that equals the number 20

Then, send an email via my connected GMAIL to a colleague

Is that possible?

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+9

Hello! Yes - It should be possible - Are you running into any particular problems here?

Only possible in zapier if there is one such row. If there are more, then the query will not retrieve all the information.

+12

Hi, @IcarusZaps! If you were able to find the query that you needed for this, we’d love to hear about it 🙂

Sign up