How to select a number from the data listed separated by commas?

Question

MySQL

I have a table dbo_scale with row scale where there is an entry 0,1,2,3,4,5,6,7,8 . And there is a table dbo_grade with a row finalgrade value 5 . I need to output a number from scale , which will be the fifth in a row, i.e. "4".

Answer 1

finalgrade - 1:D

Answer 2

SELECT 
  RIGHT(
    SUBSTRING_INDEX(`dbo_scale`.`scale`, ',', dbo_grade.`finalgrade`),
    LENGTH(dbo_grade.`finalgrade`)
  )
FROM 
  `dbo_scale`
  JOIN `dbo_grade`