0

I have this string '275,278,222'

How to SELECT only 278, which is in the second position? or SELECT only 222 which is in the third position?

Improve this question
1

1 Answer 1

Reset to default
1

second position : SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(STAFFID_, ',', 2),',',-1)

third position : SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(STAFFID_, ',', 3),',',-1)

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.