mysql
mysql计算距离:
SELECT (st_distance(point(lng,lat),point(116.3424590000,40.0497810000))*111195/1000) as juli FROM ag_user_attorney_detail WHERE Id = 67
json字符串:
SELECT * FROM table_name WHERE 表字段名-> '$.jsonkey名' LIKE "%关键字%";
json数组:(包含数组数据的模糊查询)
表字段Tim
原创
2021-04-30 14:17:52 ·
54 阅读 ·
0 评论