mysql - 如何切片以“/”分隔的字符串?
问题描述
如何切片由 分隔的字符串/
?
例子:
ID | 第 1 列 |
---|---|
01 | x/pp/llllll |
02 | lll/k/uu/llll/nbbbb |
03 | zzzzzz/www/s/aa |
我想要的是将第一个输入返回到逗号:
ID | 第 1 列 |
---|---|
1 | X |
2 | lll |
3 | zzzzzz |
解决方案
欢迎!正如 B001ᛦ 所说,根据您的数据,这可能不是一个好主意。
要操作字符串,请查看字符串函数。
SELECT SUBSTRING_INDEX(column1, '/', 1) FROM foo;
推荐阅读
- java - @Transactional rollbackFor 不在 jboss wildfly 上工作
- css - CSS file is not working in react component
- java - Hyperledger Fabric GetHistoryForKey get null pointer exception on java
- pytorch - How to view all possible distributions that can be used in PyTorch kl_divergence function?
- javascript - Implementing BST backed up by Array in Javascript
- node.js - How to pass credit card info via POST
- bash - Extract field using the ‘cut’ command and piping to find the highest value in the extracted field to a separate file
- python - Python using methods from other classes with threads
- 2sxc - 2sxc DnnEnvironment.get_DefaultLanguage()
- angular - 角度测试为什么在单击时需要刷新,但在 triggerEventHandler 中不需要