0

PostgreSQL supports two String Functions, that are incredibly useful

Both of these functions essentially take two strings, (a) a pattern and (b) an input string and return either an array[] or set of row types.

This is great for problems like this. MySQL has a JSON type, and version 8 even brings binary JSON. Does it support any string splitting into a JSON_ARRAY or the like. Or, is there an easy method to implement this?

Improve this question
3
  • 1
    Most probably not as MySQL does not have support for set returning functions (or arrays)
    – user1822
    Commented Apr 10, 2018 at 14:52
  • @a_horse_with_no_name but it does support JSON which I name explicitly a suitable alternative.
    – Evan Carroll
    Commented Apr 10, 2018 at 14:53
  • @EvanCarroll - File a feature request at bugs.mysql.com .
    – Rick James
    Commented Apr 30, 2018 at 14:44

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.