SUBSTRING_INDEX(str,delim,count): Returns the substring from string str before count occurrences of the delimiter delim : SUBSTRING_INDEX « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. SUBSTRING_INDEX

If count is positive, everything to the left of the final delimiter is returned.

If count is negative, everything to the right of the final delimiter is returned.

SUBSTRING_INDEX() performs a case-sensitive match when searching for delim.

mysql>
mysql> SELECT SUBSTRING_INDEX('www.java2s.com', '.', 2);
+-------------------------------------------+
| SUBSTRING_INDEX('www.java2s.com', '.', 2) |
+-------------------------------------------+
| www.java2s                                |
+-------------------------------------------+
1 row in set (0.00 sec)

mysql>








23.43.SUBSTRING_INDEX
23.43.1.SUBSTRING_INDEX(str,delim,count): Returns the substring from string str before count occurrences of the delimiter delim
23.43.2.SUBSTRING_INDEX('www.java2s.com', '.', -2);