mysql 如何使用JSON_EXTRACT() 取json值

SELECT JSON_EXTRACT('{"uid":"asas02234"}', "$.uid");

select
  replace(JSON_EXTRACT(infoJson,'$.uid'),'"','') uid
from users

$applyList = DB::table('invoice')
      ->select('applied_at','total_amount','invoice_fORM','invoice_file','reject_reason')
      ->selectRAW('replace(JSON_EXTRACT(invoice_detail,"$.owner_name"),\'"\',\'\') as owner_name')
      ->where('uid',Auth::id())->get();

SELECT JSON_UNQUOTE(JSON_EXTRACT('{"id":"3"}', "$.id"));

$applyList = DB::table('invoice')
      ->select('applied_at','total_amount','invoice_form','invoice_file','reject_reason')
      ->selectRAW('JSON_UNQUOTE(JSON_EXTRACT(invoice_detail,"$.owner_name")) as owner_name')
      ->where('uid',Auth::id())->get();

SELECT JSON_EXTRACT('{"ID":"1"}','$.ID');

SELECT JSON_UNQUOTE(JSON_EXTRACT('{"ID":"1"}','$.ID'));