我有弦状的
some1-some2-som3-123
some1-some2-143
some1-1235
如何删除最后一部分？从带有sql语句的字符串
最佳答案
您可以从头到尾使用simpleSUBSTRING：
SELECT col, SUBSTRING(col, 0, LENGTH(col) - INSTR(REVERSE(col), '-')) AS result
FROM tab;
-输出：
╔═══════════════════════╦══════════════════╗
║ col ║ result ║
╠═══════════════════════╬══════════════════╣
║ some1-some2-som3-123 ║ some1-some2-som3 ║
║ some1-some2-143 ║ some1-some2 ║
║ some1-1235 ║ some1 ║
╚═══════════════════════╩══════════════════╝