Skip to content

Instantly share code, notes, and snippets.

@fernandoperigolo

fernandoperigolo/searchByTaxvat.sql

Created March 20, 2017 13:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fernandoperigolo/12d7717a4cbb6355cf39c678d5ad97a4 to your computer and use it in GitHub Desktop.
Save fernandoperigolo/12d7717a4cbb6355cf39c678d5ad97a4 to your computer and use it in GitHub Desktop.
Download ZIP
This is a Query for Magento where you can search a customer by taxvat. The entity_id result is the ID of customer, so you can find easily in Magento admin
Raw
searchByTaxvat.sql
SELECT * FROM customer_entity_varchar WHERE value = "12312312312";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment