Email us at info@henrytech.org to discuss your Drupal Migration today!

By Catherine Henry, 22 August, 2023

Drupal Database Queries

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()"

Tags

Database