There are two methods to create SEO Friendly URL
Step-1: By Using Database SQL Query
select* from core_config_data where path = "web/seo/use_rewrites"
update core_config_data set value=1 where path like "web/seo/use_rewrites";
Step-2: By Using Magento 2 Admin
- Go To Admin Panel
- Stores > Settings > Configurations
- In the left panel, under General, select Web
- Open the Search Engine Optimization section
- Finally Select Yes From Drop Down