My scenario is that i have duplicate substring with string in column like
col1
QWERT
Try this:
SELECT SUM(CAST(SUBSTR(t.YourColumn, LOCATE('-',t.YourColumn)+1) as INT)) as sum_total FROM YourTable t