如何在mysql中删除字符串的一部分? [英] How to remove part of string in mysql?
问题描述
在数据库的一个表中,我有一个看起来像这样的字符串:
In one table of my database I have strings which looks like this one:
sometext-othertext
如何使用SELECT语句删除包含破折号的文本,使结果仅为sometext
?
How to remove the text including dash with SELECT statement so the result to be just sometext
?
推荐答案
在第一次出现定界符-"之前返回子字符串:
Return the substring before the first occurrence of the delimiter "-":
SELECT SUBSTRING_INDEX('foo-bar-bar', '-', 1) as result;
输出结果="foo"
Outputs result = "foo"
您可以在获取子字符串之前用所需的出现次数替换1
You can replace 1 with the numbers of occurrences you want before getting the substring
SELECT SUBSTRING_INDEX('foo-bar-bar', '-', 2) as result;
输出结果="foo-bar"
Outputs result = "foo-bar"
参考: http://dev. mysql.com/doc/refman/5.0/zh-CN/string-functions.html#function_substring-index
这篇关于如何在mysql中删除字符串的一部分?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!