Question

我存入数据库的是一个json字符串，现在我想将这个字符串原样的查出来该怎么办

[{"api":"100312","count":"1","name":"曹华","rownum":"1","sta_date":"2019-01-24","sta_time":"09:57:18","t2com":"辽宁分公司","t3com":"辽宁分公司本部"},{"api":"8901","count":"5","name":"何志强","rownum":"2","sta_date":"2019-01-24","sta_time":"09:57:18","t2com":"北京分公司","t3com":"北京分公司本部"},{"api":"4000","count":"3","name":"范雪秋","rownum":"3","sta_date":"2019-01-24","sta_time":"09:57:18","t2com":"大连分公司","t3com":"大连分公司本部"}]这是我存入数据库字段中的数据，现在我想将这条数据原样取出来

Answer 1

我也遇到过这个，数据库拿到这个数据是字符串，奇怪的是前后有两个对双引号，JSON.parse()转json就出错了。。我解决是用正则去掉前后的双引号，然后得到的就是存进去的字符串的样子了，然后在转json就成功了。

Answer 2

你去查存这个存json字符串的字段，一条select 语句不就出来了吗？你能不这样找，还能怎么找？