Can I get an overview of all Store URLs?

[marcinekno5200]

Hi,
I want to get an overview of all Store URLs using a database.
I need a list of all URLs in the database.
Someone can help me? I have no idea about that.

[zoyascootg16c3]

Hello @marcinekno5200 

Trust you are doing well,

You need to run the following query in your Magento database so you will get all store URLs.
SELECT * FROM `core_config_data` WHERE `path` = 'web/secure/base_url'
SELECT * FROM `core_config_data` WHERE `path` = 'web/unsecure/base_url'

Hope this helps you,

Problem solved? Hit the Kudos button and "Accept it as Solution"