How to choose the last word in a line

Question

I used

SELECT SUBST(field_name, 1, Locate('',field_name)) AS first_word FROM table_name

and it works for the first word, so I tried to use last_word, but still get the first word, so I suppose there should be a different way.

+4

RDiedrick Oct 23 '10 at 22:01

2 answers

GSto · Answer 1 · 2012-02-01T15:24:31+0000

Select SUBSTRING_INDEX(field_name,' ',-1)

eaolson · Answer 2 · 2010-10-23T22:12:58+0000

Well, you could probably do:

 SELECT REVERSE( SUBST( REVERSE( field_name ), 1, LOCATE( ' ', REVERSE( field_name )))

This probably won't work if your field has spaces or a single word.