How do I update multiple records in MySQL database, based upon 1 selected dropdown value in a table

How do I update multiple records in MySQL database, based upon 1 selected dropdown value in a table?

The value selected in dropdown in the table should update all the records with the same projectID of that row where I'm updating the dropbox

The dropdown's value will only activate / evaluate as the changed value if you save the table. You could run a JS query on table save that will run a `setValue` of a temporary state that you could reference and filter through for that changed value.