lasciati ispirare

SELECT SUBSTRING_INDEX('https://forum.html.it/forum/newthread.php?do=newthread&forumid=98', '/', 3);