How to update Blob data in users table? I am trying to update data filed in users table. 



Please suggest a way how to update this field data with help of query or need to follow some other approach ?

$old_user_id = 123;
$new_user_id = 456;

$account_old = user_load($old_user_id);
$account_new = user_load($new_user_id);

if ($account_old &amp;&amp; $account_new &amp;&amp; !empty($account_old-&gt;data['uc_stripe_customer_id'])) {
  user_save($account_new, array('data' =&gt; array('uc_stripe_customer_id' =&gt; $account_old-&gt;data['uc_stripe_customer_id'])));
}


Thanks!
It's a serialised PHP array.

You would, in my humble opinion, be nuts to try to parse this with SQL.

Use PHP to unserialize, make your changes, serialize it again, and write the result to the database.