Running the SUBSTRING_INDEX query on a column
<p>I have this column called <code>location</code> in a table called <code>raw_data</code>. Each row have lots of varchar data separated by <code>[, ]</code>. Examples</p>

<p>Row 1 <code>dusseldorf, kjsbdfygs4, Germany</code></p>

<p>Row 2 <code>768768745h, kiev, Ukraine</code></p>

<p>Row 3 <code>%%%%666, Accra, Ghana</code></p>

<p>Yes some make no sense. Im trying to select the <code>last part</code> of the string which is the <code>country</code> and display it.
I tried using the <code>substring index</code> query and understand how it works but cant seem to understand how to apply it to a column.</p>