'Remove first part of string in MySQL [duplicate]
I would like to remove the first part of the string and the comma that seperates the string.
Current code that produces data:
SELECT PrizeMoneyBreakDown from race2;
SELECT
SUBSTRING_INDEX((SUBSTRING_INDEX(PrizeMoneyBreakDown,';',1)),';',-1) AS 1st,
FROM race2
Data:
1st,4000
1st,4550
1st,4550
1st,4550
1st,4550
Desired output:
4000
4550
4550
4550
4550
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
