本文介绍了 MySQL 中 SUBSTRING_INDEX 函数的使用方法，该函数用于返回字符串 str 在指定分隔符 delim 出现 count 次之前的部分。如果 count 为正数，则返回从左边数第 count 个分隔符左边的所有字符；若 count 为负数，则返回从右边数第 count 个分隔符右边的所有字符。示例展示了如何利用此函数进行字符串切割。
SUBSTRING_INDEX(str,delim,count)
Returns the substring from string str before count occurrences of the delimiter delim. If count is positive, everything to the left of the final delimiter (counting from the left) is returned. If count is negative, everything to the right of the final delimiter
(counting from the right) is returned. SUBSTRING_INDEX() performs a case-sensitive match when searching for delim.
mysql> SELECT SUBSTRING_INDEX('www.mysql.com', '.', 2);
-> 'www.mysql'
mysql> SELECT SUBSTRING_INDEX('www.mysql.com', '.', -2);
-> 'mysql.com'
This function is multi-byte safe.
扫一扫
120
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
