In one table of my database I have strings which looks like this one:
sometext-othertext
How to remove the text including dash with SELECT statement so the result to be just sometext?
Add a comment
|
5 Answers
Return the substring before the first occurrence of the delimiter "-":
SELECT SUBSTRING_INDEX('foo-bar-bar', '-', 1) as result;
Outputs result = "foo"
You can replace 1 with the numbers of occurrences you want before getting the substring
SELECT SUBSTRING_INDEX('foo-bar-bar', '-', 2) as result;
Outputs result = "foo-bar"
Reference: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substring-index
1 Comment
Rami Alshareef
Reference - dev.mysql.com/doc/refman/5.0/en/…
SELECT REPLACE("sometext-othertext","-", "") as newvalue
This should do it.
Edit:
SELECT SUBSTRING_INDEX('sometext-othertext', '-', 1) as newvalue;
apologies for not understanding the question earlier.
have two ways to use troubleshooting this, if you like to display all (only just remove "-" symbol, i recommended use this because have more speed:
SELECT REPLACE('sometext-othertext','-','');
that syntax change text "-" to "" (empty text because you want just remove that)
if you want to display only part one (ex :sometext) or just part two (ex :othertext) you can use this, for spliting string:
SELECT SUBSTRING_INDEX('sometext-othertext', '-', 1);
Comments
better use mysql REPLACE function to replace "-" with ""
2 Comments
jensgram
That is not the entire goal. Everything following the first dash should be removed.
DhruvPathak
Sorry, I misunderstood the question.