<!-- THEME DEBUG --> <!-- THEME HOOK: 'field' --> <!-- FILE NAME SUGGESTIONS: ▪️ field--node--title--article.html.twig ✅ field--node--title.html.twig ▪️ field--node--article.html.twig ▪️ field--title.html.twig ▪️ field--string.html.twig ▪️ field.html.twig --> <!-- BEGIN OUTPUT from 'themes/contrib/classy/templates/field/field--node--title.html.twig' --> <span class=Drupal Database Queries ">

Drupal Database Queries

Drupal 8
Database queries
Database
Drush

Regular query

$connection = \Drupal::database();

$user_id = '1043651';

$query_result = $connection->select('table_name', 'tn')
  ->fields('tn', ['column_name_1', 'column_name_2',])
  ->condition('uid', $user_id)
  ->execute()
  ->fetchAll();

A Query using Drush

drush ev "return db_query('SELECT * FROM table_name WHERE entity_id=20603’)->fetchAll()"