update table column if provided text is not matched
You can update all your table with query:

UPDATE table 
   SET value = IF(merchantDetails = "Amazon.com", "AMZ", "FBA");


where table and value should be changed to the actual names of table and field.