I am using magento 2 enterprise edition i am trying to get products URL from sql database for this i have seen catalog_products_entity_varchar but in value attribute column products imgages are given so please help me about this problem
you can get it form url_rewrite table
there are entity_id is product_id and request_path is display url
You need to do following steps.
- Open the table "eav_attribute" and search the record with this condition "entity_type_id" = 4 and "attribute_code" = sku
so now you get the row which show the attribute_id for the url_key something like this.
In demo case it is 121.
- Now open the "catalog_product_entity_varchar" table and serch the record by "attribute_id" = 121
And finaly you get the product URL like this one.
If you are trying to make the query, then you need to write like this :
SELECT * FROM 'catalog_product_entity_varchar' WHERE 'attribute_id' = 121