select an item in DB based on several fields

Thierry MARTIN

Hi guys,

Is there a way to select a record in the database, based on the value of more than 1 field?

My table contains 3 fields (in addition to standard id and created_at)
• user_id
• release_id
• folder

and I have to update the folder field of a record matching both user_id and release_id.
How could I do that?

Thierry MARTIN

I've found a way.
I first do a "query all records" with the appropriate constraints, and then edit the found record.

In case there is a better way, please let me know 😉

Michael Udinski

Hi  - that is the way I would do it!