Extract state from business location

[bimalpoudel]

One of my table has a field - business_location, with the following kind of records:

Melbourne, VIC
Hyde Park, QLD
Sydney, NSW
Ormeau, QLD
Ormond, VIC

Is there a quick way to extract the states, using a query?
I would like to take the last word and put into different column.

For example, extract VIC from "Ormond, VIC", using some features at mysql level to select().

[r937]

using the space as the delimiter, pull off the last word like this --

SUBSTRING_INDEX(business_location, ' ', -1)

[bimalpoudel]

Pretty nice.
I have checked my entire data that the last words are always one-word as the state.

Thanks.