Results 1 to 3 of 3
Jul 1, 2011, 01:36 #1
- Join Date
- Feb 2009
- Kathmandu, Nepal
- 0 Post(s)
- 0 Thread(s)
Extract state from business location
One of my table has a field - business_location, with the following kind of records:
Hyde Park, QLD
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().