Advertisement
Guest User

Untitled

a guest
Jul 23rd, 2019
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. CREATE 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.  
  8. SELECT JSON_EXTRACT(json,'$.input_value_'.$x) FROM some_table WHERE some_condition
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement