Select Get single value: $query = \Drupal::database()->select('node_field_data', 'nfd'); $query->addField('nfd', 'nid'); $query->condition('nfd.title', 'Potato'); $query->range(0, 1); $nid = $query->execute()->fetchField(); Get single row: $query = \Drupal::database()->select('node_field_data', 'nfd'); $query->fields('nfd', ['nid', 'title']); $query->condition('nfd.type', 'vegetable'); $query->range(0, 1); $vegetable = $query->execute()->fetchAssoc(); Using db like: $query = \Drupal::database()->select('node_field_data', 'nfd'); $query->fields('nfd', ['nid', 'title']); $query->condition('nfd.type', 'vegetable'); $query->condition('nfd.title', $query->escapeLike('ca') . '%', 'LIKE'); $vegetable = $query->execute()->f...