Example: SetKey, GotoNearest

To set cursor to row in which City field begins with 'Santa':

with MySQLTable1 do
begin
  SetKey;
  FieldByName('State').AsString := 'CA';
  FieldByName('City').AsString  := 'Santa';
  GotoNearest;
end;