mysql string split
SELECT SUM(amt) FROM table1 WHERE id in (114,116) and another_id = 10;

result is 10+20 = 30

SELECT SUM(amt) FROM table1 WHERE id in (REPLACE("116,114",'"',"")) and another_id = 10;

result is 10

WHERE CONCAT('%,', id, ',%') LIKE ('${submitted_string}')

SELECT SUM(amt) FROM table1 WHERE ","+CAST(id AS CHAR)+"," in (","+"116,114"+",")
                             and another_id = 10;