Which SQL Query To Display Multiple Websites & Stores in Magento 2.x

There are following below SQL Query need to run.


SELECT * FROM `core_config_data` WHERE path in 
("web/unsecure/base_url", 
  "web/unsecure/base_link_url", 
  "web/secure/base_url", 
  "web/secure/base_link_url"
);

As above Query, when run Query, display all websites / Stores in Magento 2

[1] Scope_ID = 0 & Its Website Value = http://dev.abc.com/

[2] Scope_ID = 2 & Its Website Value = http://dev.xyz.com/

[3] Scope_ID = 6 & Its Website Value = http://dev.pqr.com/

[4] Scope_ID = 10 & Its Website Value = http://dev.demo.com/

[5] Scope_ID = 13 & Its Website Value = http://dev.demostore.com/

Here Scope_ID Refer Store ID

Leave a Reply Cancel reply