selecting substring using split in mysql

Mysql does not have a split like function but its subsrtring_index function can be utilized on certain situations


SUBSTRING_INDEX(str,delim,count)


Example : Substring_index("Korea, Republic",",",1)

will return us only the first part before delimiter. i.e Korea

if we need second part we can use it as
substring_index("Korea, Republic",",",2)