Bug #82311 | Retrieve the last value of an array (JSON_POP) | ||
---|---|---|---|
Submitted: | 21 Jul 2016 18:43 | Modified: | 21 Mar 2018 11:28 |
Reporter: | André Jacques | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: JSON | Severity: | S4 (Feature request) |
Version: | >5.7 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | JSON_POP |
[21 Jul 2016 18:43]
André Jacques
[21 Mar 2018 11:28]
Knut Anders Hatlen
Thanks for the enhancement request. In MySQL 8.0 you can do the following: mysql> select dates->'$[last]' from t; +------------------+ | dates->'$[last]' | +------------------+ | "2016-01-05" | +------------------+ This was implemented in WL#9831.