MySQL Forums
Forum List  »  Spanish

Re: Leer datos dentro de campo varchar
Posted by: Peter Brawley
Date: August 16, 2021 11:51AM

JSON_TYPE () dice que la cadena es una matriz JSON. Para ello, JSON_PRETTY () devuelve ...

| [
  {
    "id ": "3651 ",
    "qty ": 1,
    " name  ": " PAPER  ",
    "section ": "2 ",
    "conf_qty ": "1.000 ",
    "conf_price  ": " 0.00  "
  },
  {
    " id  ": " 3683  ",
    " qty  ": 1,
    " name  ": " BLUE  ",
    " section  ": " 1  ",
    " conf_qty  ": " 1.000  ",
    " conf_price  ": " 0.00  "
  }
] |

Deberá usar JSON_EXTRACT () (https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html#operator_json-column-path) para extraer valores de dichas cadenas. Desafortunadamente, no uso JSON lo suficiente como para ser de mucha ayuda con eso.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Leer datos dentro de campo varchar
155
August 16, 2021 11:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.