Substract string index : Sub String : String SQL / MySQL

Ajax
Ajax Examples Ajax Tutorials Scripts and Programs
Javascript
Javascript Examples Tutorials DHTML Tutorials Javascript References Scripts and Programs
HTML
HTML Tutorials HTML References HTML DOM 0 References HTML DOM 2 References
CSS
CSS Tutorials CSS References
PHP
PHP Source Code PHP References Scripts and Programs
C#
C# Source Code C# Examples

SQL / MySQL » String » Sub 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);