error with where

[peterramsis]

when I use where like this :

$user = User::where('name->en' , "admin")->get();

SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION gym.json_unquote does not exist (SQL: select * from roles where json_unquote(json_extract(name, '$."en"')) = admin)

or

$user = User::whereRaw("JSON_EXTRACT(name, '$.en') = 'Peter Ramsis'")->get();

SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION gym.JSON_EXTRACT does not exist (SQL: select * from users where JSON_EXTRACT(name, '$.en') = 'Peter Ramsis')

How I Fix it ?

[ArtMin96]

Same error here:

PermissionsGroup::with(['permissions' => fn($query) => $query->where('name->en', $guard)])->get()

SQLSTATE[22032]: <>: 3141 Invalid JSON text in argument 1 to function json_extract: "Invalid value." at position 0. (SQL: select * from permissions where permissions.group_id in (1, 2, 3, 4) and json_unquote(json_extract(name, '$."ru"')) = web)

[HassanElshazlyEida]

same ..