mysql JSON_SEARCH LIKE

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

Source

Also in JavaScript: