Where is the status of "Confirmed email" saved in the database?

How can I change the value directly in the database for this customer?

enter image description here

I searched everywhere, but I can't find the table where this relation between customer and attribute is stored.

I searched in

  • 1
    SELECT entity_id,confirmation,email FROM customer_entity;
    – S.P
    Commented May 3, 2022 at 13:42

1 Answer 1


It is static attribute you could not find it on above three table.

it would save in "customer_entity" table itself.

Execute Below query for more details.

SELECT entity_id,confirmation,email FROM `customer_entity`;
SELECT * FROM `eav_attribute` WHERE (`attribute_code` LIKE '%confirmation%');
SELECT * FROM `customer_eav_attribute` where attribute_id in (SELECT attribute_id FROM `eav_attribute` WHERE (`attribute_code` LIKE '%confirmation%'));

Any eav_attribute which value is static in backend_type column, That value would saved in main table ( for product = catalog_product_entity , for customer = customer_entity, ..)

For track,

Magento\Customer\Block\Adminhtml\Edit\Tab\View\PersonalInfo.php :: getIsConfirmedStatus


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.