Remove first part of string in MySQL

Question

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:

You are testing for ; (semi-colon) in substring_index but your data has , (comma) is that a typo? — P.Salmon, Mar 01 '22 at 11:18

score 0 · Accepted Answer · answered Mar 01 '22 at 11:19

0

The following query will take the 5-th character of the string till the end :

SELECT
   SUBSTRING(PrizeMoneyBreakDown,5,length(PrizeMoneyBreakDown)) as st1
FROM race2

Or using your method, change the ; with ; and 1 to -1 to take the second part of the string

SELECT
   SUBSTRING_INDEX((SUBSTRING_INDEX(PrizeMoneyBreakDown,',',-1)),',',1) AS 1st
FROM race2

answered Mar 01 '22 at 11:19

Ergest Basha

Thanks. This leave me with a semi-colon at the end of the outputed data. How do I remove this? – kjdcwckj Mar 01 '22 at 12:31
@kjdcwckj you could use replace , check https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=4d6d5de93bd80e94235c34106798605e – Ergest Basha Mar 01 '22 at 13:06

1 Answers1