sqlite finding row id that has a value in a specfic column and updating that row

Using a sqlite data base in a program.

The program iterates through data in an api and stores it. The sqlite database is initialized and data is stored into it. The code I am showing you is updating the data base with new information

The goal is to first find the row ID that has a specific value in a specific column.

then take that row ID and use it to update columns within that row.

 for row in db().select(
    db.venue.ALL, orderby = db.venue.VariableName, having = Number ):

    row.update_record (has_private_dining = True,
                   private_dining_description = Description,
                   private_dining_rooms = roomResults,
                   food_types = foodTypes,
                   neighborhood = Neighborhood)

What happened when I did this was each row had the same information in it. What should have happened was each row would have the updated information in it for the specfic row ID of the variableName with the Number in it, that was being checked for that iteration.

The Docs are being frustrating can I have a human help me out here please?