Extract slugs from URL’s in MySQL

So, say for a database update, which for some reason you cannot script using your normal scripting language, you need to extract a part of a URL (a slug for example) from a complete URL

SELECT TRIM(BOTH '/' FROM SUBSTRING(TRIM(LEADING '/' FROM link_url), 
locate('/', TRIM(LEADING '/' FROM link_url)))) FROM page_links

Add comment