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数组：(包含数组数据的模糊查询)

表字段TimeBucketJson:

[{"DayOfWeek":1,"TimeRangeList":"00:00~01:00,01:00~02:00,02:00~03:00,03:00~04:00"},{"DayOfWeek":2,"TimeRangeList":""},{"DayOfWeek":3,"TimeRangeList":""}

,{"DayOfWeek":4,"TimeRangeList":""},{"DayOfWeek":5,"TimeRangeList":""},{"DayOfWeek":6,"TimeRangeList":""},{"DayOfWeek":7,"TimeRangeList":""}]

select * from table_name where

JSON_CONTAINS(TimeBucketJson,JSON_OBJECT('DayOfWeek', #{dayOfWeek},'TimeRangeList',#{timeRange}))

and (json_extract(TimeBucketJson, "$[0].TimeRangeList") like CONCAT('%',#{timeRange},'%')

or JSON_CONTAINS(TimeBucketJson,JSON_OBJECT('TimeRangeList', '全天'))

)