Eternal Night

Tagged: replace

表：pub_log 中的字段：data 的数据结构为：json，格式化后的数据如下 0

Yii / MySQL 5.6 / MySQL 5.7 / PHP 7.2 / Yii 2 / Web Application Development / Database / Programming Language / MySQL / PHP / SQL

In Yii 2.0, modify a column of data in the MySQL 5.6 database (type: text, the data structure is: json) in the value of a field (that is, to search and replace some text in the field), based on one Implementation of SQL

浏览量： 1 1. Table: Fields in pub_log: The type of data is: text, as shown in Figure 1 2. Table: field in pub_log: data structure of data is: json, the formatted data is as...