I have this code:
SET @startEndTimeCapacity = "'00:00:00', '08:00:00', 120";
SELECT SUBSTRING_INDEX(@startEndTimeCapacity, ",", 2);
results in '00:00:00', '08:00:00'.
How can I get the 2nd value '08:00:00' only?
SUBSTRING_INDEX get nth value
Viewed 62
1 Answers
You can apply the SUBSTRING_INDEX function twice:
- for splitting at the nth value
- for retrieving the last value in the previous list
Here's how:
SUBSTRING_INDEX(SUBSTRING_INDEX(@startEndTimeCapacity, ",", 2), ',', -1);
This works for any n. In this specific case n=2.
Related