Remove last part of link text mysql

mysql remove characters from string
mysql remove last character
mysql trim
mysql substring
mysql remove first character from string
mysql left
mysql trim spaces
replace special characters in mysql query