The following code uses the EditKey and GotoKey methods to move to a particular record on MySQLTable1.
The actual field values are not changed when making the assignments because of the call to EditKey.
with MySQLTable1 do
begin
EditKey;
FieldByName('State').AsString := 'CA';
FieldByName('City').AsString := 'Santa Barbara';
GotoKey;
end;