search to update several rows
Can somebody refresh my memory on how to build a query for this.
I want to use a list of several names (first and last), to update their rows in the table with same information. for example:
if I have a table set up with the columns:
I want to find:
and edit their field for [married_status] to 'm'.
how do I structure this search and replace?