Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS some_table
- (
- `json` JSON NOT NULL
- ) COLLATE='utf8_general_ci' ENGINE=InnoDB;
- {"input_value_1":1, "input_value_2",...."input_value_10":10}
- SELECT JSON_EXTRACT(json,'$.input_value_'.$x) FROM some_table WHERE some_condition
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement