1:SELECT json_extract(jsonData,'$.listings[*].property_id') FROM realtor_list_page_json
2:SELECT json_array_elements("jsonData"->'listings')->> 'property_id' FROM realtor_list_page_json
一直没找到mysql全部分开显示的东西语句;
1:SELECT json_extract(jsonData,'$.listings[*].property_id') FROM realtor_list_page_json
2:SELECT json_array_elements("jsonData"->'listings')->> 'property_id' FROM realtor_list_page_json
一直没找到mysql全部分开显示的东西语句;