|
|
selecting substring using split in mysql - Mysql
|
Views : 289
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
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) |
|
By rajesh, On - 2011-06-29 |
|
|
|
