Could you let me know where is customer firstname and lastname being stored in magento 1 database table ?

I didn't seem to find them in customer_address_entity or customer_entity.

I wanted to select all customers from my database whose total characters in name is greater than 15

2 Answers 2


check this table customer_entity_varchar


Customer firstname and lastname is stored in customer_entity table. Checkout below link of install schema of customer_entity table for magento 1.0.0-beta6 version.


  • Question was for M1
    – sv3n
    May 11, 2023 at 17:41
  • I have updated the answer.
    – Harsh Tank
    May 20, 2023 at 0:13

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.