【MySQL】字符串截取至第N个字符的位置
截取字符串中指定字符的正着数的位置
1 2 3 4 5 6 7 8 9 |
mysql> SELECT SUBSTRING_INDEX('/a/b/c/d/xxf.txt','/',3); +-------------------------------------------+ | SUBSTRING_INDEX('/a/b/c/d/xxf.txt','/',3) | +-------------------------------------------+ | /a/b | +-------------------------------------------+ 1 row in set mysql> |
截取字符串中指定字符的倒着数的位置
1 2 3 4 5 6 7 8 9 |
mysql> SELECT SUBSTRING_INDEX('/a/b/c/d/xxf.txt','/',-1); +--------------------------------------------+ | SUBSTRING_INDEX('/a/b/c/d/xxf.txt','/',-1) | +--------------------------------------------+ | xxf.txt | +--------------------------------------------+ 1 row in set mysql> |