MySQL query, how to discard the last word in a string?

Question

MySQL

I didn’t find a function on the run, I came up with a monster

SELECT REVERSE(SUBSTR(REVERSE(trackname_full), POSITION(' ' IN REVERSE(trackname_full))+1)) as alt ...

You can do this in PHP, but I wonder what MySQL has for this?
How much this request "brake"?

Answer 1

Можно и другим "монстром" :-)

select substring_index(st1, ' ', length(st1) - length(replace(st1,' ',''))) as alt ....

Answer 2

а если перед словом не пробел, а другой разделяющий символ?
может поможет:www.mysql.ru/docs/man/Regexp.html