inonetableofmydatabaseihavestringswhichlookslikethisone :
sometext-othertext
howtoremovethetextincludingdashwithselectstatementsotheresulttobejustsometext？
returnthesubstringbeforethefirstoccurrenceofthedelimiter '-' :
select substring _ index (' foo-bar-bar '，'-'，1 ) as result；
Outputs result='foo '
you can replace1withthenumbersofoccurrencesyouwantbeforegettingthesubstring
select substring _ index (' foo-bar-bar '，'-'，2 ) as result；
Outputs result='foo-bar '