Extract state from business location

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().

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

SUBSTRING_INDEX(business_location, ' ', -1)

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