Shulou(Shulou.com)06/01 Report--

This article is about how to deal with JSON fields in Mysql. The editor thought it was very practical, so I shared it with you as a reference. Let's follow the editor and have a look.

Mysql can handle json. To handle the JSON field in Mysql, you can use the json_extract function, for example, "SELECT * FROM proxy WHERE json_extract (content," $. Method ") =" POST ";" statement.

Dealing with JSON fields in Mysql

To handle the json field, you can use the json_extract function:

Select * from (select json_extract (ext_value,'$.high') + 0 highx,batch_id from batch_ext_1 where ext_type=19) a where a.highx > 15000000000SELECT * FROM proxy WHERE json_extract (content, "$.method") = "POST"

To convert the string value in the json field to a numeric value, you can use + 0, as in the above statement.

Json_extract (ext_value,'$.high') + 0 highx

Will eventually become digital.

Thank you for reading! On how to deal with the JSON field in Mysql to share here, I hope the above content can be of some help to you, so that you can learn more knowledge. If you think the article is good, you can share it and let more people see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.