query json mysql code example

Example 1: mysql JSON_SEARCH LIKE

$query=$query->whereRaw('UPPER(education->"$[*].profession") LIKE UPPER("%' . $profession . '%")');

Example 2: mysql json

SELECT json_clmn->'$.property' FROM table