你即將離開本站

並前往https://techinplanet.com/how-to-convert-a-json-array-to-comma-separated-string-in-mysql/

How to convert a JSON array to comma separated string in ...

Assuming you are using mysql 8.0 then you can use JSON_TABLE with CROSS JOIN and GROUP_CONCAT to achieve this: Try below query:

確定！ 回上一頁

查詢 「MySQL JSON_TABLE」的人也找了：

  1. MySQL JSON_TABLE
    2.
  2. MariaDB JSON_TABLE
    3.
  3. MySQL JSON array to rows
    4.
  4. JSON table example
    5.
  5. MySQL JSON array index
    6.
  6. Mysql JSON_SEARCH
    7.
  7. MySQL JSON type
    8.
  8. MySQL JSON_OBJECT
    9.