I am looking for the syntax to change the name of salesperson Inga to Annette, but only where Inga's SALES are <50 I have attached a screenshot of the database - I have tried every syntax I can think of, I am positive it will be simple - I have just been stuck on this for a while. by CodeGirl2022 in StackOverflow on June 05, 2022 . Answer You can use UPDATE statement, like this: UPDATE tablename SET SalesPerson="Annette" WHERE SalesPerson="Igna" AND SalesAmount>50; by Vad Sim on June 05, 2022 .