. I'm trying to write a module for Drupal 7 and I need to convert. I need to convert the following query for Drupal 7: SELECT. hook_update_N (), which will be. function db_update. 8 database.inc. $query = db_update. Can someone please explain me how to write a db_update for a BLOB field? Drupal SQL query examples, includes regular query and select, insert, update and insert or update using abstraction. drupal_write_record ('social_networks. Hi All, I want to execute below sql query using Drupal 7 PDO, But could not find a way to do, SQL: UPDATE books AS a JOIN books b ON a.pid = b.pid Update same table using dynamic query in drupal 7. $query- fields($update. 36400'),' ')*/ $isbn_reds = $query- execute(); How can we write above SQL in. function drupal_write_record. 6 common.inc. SAVE_UPDATED is always returned when an update SQL query is performed. Search Drupal 7. Function, file. MySQL UPDATE and Drupal 7. Submitted. you use expressions to create such a query and they are executed in the same order as. you can write expression('f1. Insert Query in Drupal 7. ($data); drupal_write_record($table. I have this insert query but somehow records are not going in to the table.can anyone. Help with db query in drupal - if exists update else insert. drupal insert or update DB record with only one function. if ($update) return drupal_write. Home / Development / Writing Efficient Queries in Drupal. Write Queries with. Thanks to Drupal’s object query builder built on PHP’s PDO you can write.