How can I use where AND to update rows with mysql

[mcadenas]

How can I Use "AND" to update rows with mysql for example:

order_status_id=39 where order_id= (3.text formater by pabbly tex parser) AND total=(2.text formater by pabbly tex parser) and order_status_id= 2



Thanks!

 

[Pabblymember11]

Hey @mcadenas

For your concern, you can use the "Get Rows" action step to retrieve rows on the basis of the MySQL WHERE clause and after getting the relative row you can update the particular row with the help of the "Update Row" action event.

 

[mcadenas]

Hi! , thanks for answer, do you have some example how to get rows using WHERE clause with BOOLEAN AND operator ? I just see only an option to use Where

 

[Pabblymember11]

Hey @mcadenas

You can also try the "Custom Query" action event to use the WHERE and AND clauses.

Kindly give it a try and let us know if that works for you.

 

[mcadenas]

Yes I did it and it works! Thank you