Running the SUBSTRING_INDEX query on a column

Question

I have this column called location in a table called raw_data. Each row have lots of varchar data separated by [, ]. Examples

Row 1 dusseldorf, kjsbdfygs4, Germany

Row 2 768768745h, kiev, Ukraine

Row 3 %%%%666, Accra, Ghana

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

Zafar Malik · Accepted Answer · 2016-04-07 10:45:51Z

1

You can use as per below-

SELECT SUBSTRING_INDEX(my_column,',',-1) FROM raw_data;

Note: If you need 1st part then use only 1 instead of -1.

answered Apr 7, 2016 at 10:45

Zafar Malik

6,8723 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ankit Agrawal · Accepted Answer · 2016-04-07 10:49:17Z

0

use like this

SELECT SUBSTRING_INDEX(location ,',',2);

go to below link for explanation

http://www.w3resource.com/mysql/string-functions/mysql-substring_index-function.php

answered Apr 7, 2016 at 10:49

Ankit Agrawal

2,4541 gold badge17 silver badges28 bronze badges

Collectives™ on Stack Overflow

Running the SUBSTRING_INDEX query on a column

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related