数据库某个字段是json类型,存放的是["1","2","3"]
用下面这种方式查:
SELECT * from wdk_local_region where area_codes like concat ('%','330102','%');
下面这种方式查不出来:
SELECT * from wdk_local_region where json_contains(area_codes, '330102');
数据库某个字段是json类型,存放的是["1","2","3"]
用下面这种方式查:
SELECT * from wdk_local_region where area_codes like concat ('%','330102','%');
下面这种方式查不出来:
SELECT * from wdk_local_region where json_contains(area_codes, '330102');