Mega Code Archive

 

Categories / MySQL / String

 

Substract string index

/* mysql> select substring_index('1,2,3,4,5,6,7,8,9',",",2); +--------------------------------------------+ | substring_index('1,2,3,4,5,6,7,8,9',",",2) | +--------------------------------------------+ | 1,2                                        | +--------------------------------------------+ 1 row in set (0.01 sec) */   select substring_index('1,2,3,4,5,6,7,8,9',",",2);