通过从mysql中的字符串中删除第一个字符来查找sum

Question

input_table

username  input
A         A10
B         A9
C         A8
D         A7
E         A0
F         A4

like so on

How i can find sum of input by removing 'A' char from 'input' field

Answer 1

Try the below code

select SUM(SUBSTRING(input, 2)) from input_table