Question

MYSQL Query? I thinnk that's what I need

  • 28 October 2020
  • 3 replies
  • 57 views

Userlevel 1

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.

3 replies

Userlevel 7
Badge +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.

Userlevel 7
Badge +12

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