mysql json查詢

• JSON_EXTRACT及->的使用

  SELECT *, JSON_EXTRACT(data,'$.text_2'), data->'$.text_2' from tb_test
  WHERE JSON_EXTRACT(data,'$.text_2') = "test";
             

• JSON_UNQUOTE去除結果的引号

  SELECT DISTINCT(JSON_UNQUOTE(JSON_EXTRACT(data,'$.text_2'))) from tb_test
  WHERE JSON_EXTRACT(data,'$.text_2') = "test";