Magento Forum

Get Customer Attribute or password from Query in Magento
 
pradeep_kumar67
Sr. Member
 
Avatar
Total Posts:  160
Joined:  2010-06-24
Bangalore
 

Hi,

We can get Customer attribute like password,email etc… from mysql Query

use below query

SELECT ce.*, ea.attribute_code, cev.value
FROM customer_entity AS ce
LEFT JOIN eav_attribute AS ea ON ce.entity_type_id = ea.entity_type_id AND ea.backend_type = ‘varchar’
LEFT JOIN customer_entity_varchar AS cev ON ce.entity_id = cev.entity_id AND ea.attribute_id = cev.attribute_id

File Attachments
custmer.sql  (File Size: 1KB - Downloads: 39)
 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top