dxRG4gwY

1CREATE TABLE IF NOT EXISTS some_table
2(
3  `json` JSON NOT NULL
4  ) COLLATE='utf8_general_ci' ENGINE=InnoDB; 
5     
6{"input_value_1":1, "input_value_2",...."input_value_10":10} 
7     
8SELECT JSON_EXTRACT(json,'$.input_value_'.$x) FROM some_table WHERE some_condition