1 | UPDATE locality SET weather = '{\"date\":\"2024-04-25\",\"data\":{\"2024-04-25\":{\"01\":{\"temp\":-4,\"pressure\":1024,\"humidity\":77,\"icon\":\"01n\",\"wind\":6},\"04\":{\"temp\":-5,\"pressure\":1025,\"humidity\":78,\"icon\":\"01n\",\"wind\":5},\"07\":{\"temp\":-4,\"pressure\":1027,\"humidity\":71,\"icon\":\"01d\",\"wind\":6},\"10\":{\"temp\":0,\"pressure\":1028,\"humidity\":53,\"icon\":\"01d\",\"wind\":5},\"13\":{\"temp\":4,\"pressure\":1027,\"humidity\":43,\"icon\":\"01d\",\"wind\":6},\"16\":{\"temp\":5,\"pressure\":1026,\"humidity\":43,\"icon\":\"04d\",\"wind\":5},\"19\":{\"temp\":1,\"pressure\":1027,\"humidity\":62,\"icon\":\"04n\",\"wind\":2},\"22\":{\"temp\":-2,\"pressure\":1029,\"humidity\":75,\"icon\":\"02n\",\"wind\":3}},\"2024-04-26\":{\"01\":{\"temp\":-2,\"pressure\":1030,\"humidity\":72,\"icon\":\"02n\",\"wind\":2},\"04\":{\"temp\":-3,\"pressure\":1032,\"humidity\":68,\"icon\":\"01n\",\"wind\":1},\"07\":{\"temp\":2,\"pressure\":1033,\"humidity\":49,\"icon\":\"03d\",\"wind\":2},\"10\":{\"temp\":7,\"pressure\":1032,\"humidity\":43,\"icon\":\"01d\",\"wind\":3},\"13\":{\"temp\":9,\"pressure\":1031,\"humidity\":41,\"icon\":\"03d\",\"wind\":4},\"16\":{\"temp\":10,\"pressure\":1030,\"humidity\":44,\"icon\":\"04d\",\"wind\":3},\"19\":{\"temp\":4,\"pressure\":1031,\"humidity\":72,\"icon\":\"04n\",\"wind\":3},\"22\":{\"temp\":2,\"pressure\":1031,\"humidity\":77,\"icon\":\"01n\",\"wind\":2}},\"2024-04-27\":{\"01\":{\"temp\":1,\"pressure\":1032,\"humidity\":81,\"icon\":\"01n\",\"wind\":2},\"04\":{\"temp\":0,\"pressure\":1032,\"humidity\":83,\"icon\":\"01n\",\"wind\":2},\"07\":{\"temp\":6,\"pressure\":1032,\"humidity\":64,\"icon\":\"01d\",\"wind\":2},\"10\":{\"temp\":12,\"pressure\":1030,\"humidity\":49,\"icon\":\"04d\",\"wind\":1},\"13\":{\"temp\":15,\"pressure\":1027,\"humidity\":39,\"icon\":\"04d\",\"wind\":2},\"16\":{\"temp\":15,\"pressure\":1025,\"humidity\":48,\"icon\":\"04d\",\"wind\":2},\"19\":{\"temp\":10,\"pressure\":1024,\"humidity\":61,\"icon\":\"04n\",\"wind\":2},\"22\":{\"temp\":8,\"pressure\":1023,\"humidity\":66,\"icon\":\"04n\",\"wind\":4}}}}' WHERE id = 18013 LIMIT 1 |
0 | SELECT * FROM `category` WHERE `id` IN ('96','97','98','99','100','102','103','104','108','110','111','113','116','118','119','120','121','123','124','125','127','128','130','131','132','133','134','136','137','138','154','164','169','176') ORDER BY name |