Size: a a a
RE
::where('fields','@>','[' . json_encode(['value' => 'петя']) . ']')->get();Gt
AH
Gt
AH
::where('fields','@>','[' . json_encode(['value' => 'петя']) . ']')->get();{"fields": [{"value": "петя"}]}{"fields": [{"value": "петя петров"}]}RE
{"fields": [{"value": "петя"}]}{"fields": [{"value": "петя петров"}]}RE
AH
::whereJsonContains('fields',[['name' => '%петя%']])->get();JSON_SEARCH
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-searchDB::table('mytable')
->whereRaw("JSON_SEARCH('fields', 'all', '%?%')", ['петя'])
->get();
Не уверен сработает ли в таком виде...RE
JSON_SEARCH
https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-searchDB::table('mytable')
->whereRaw("JSON_SEARCH('fields', 'all', '%?%')", ['петя'])
->get();
Не уверен сработает ли в таком виде...SV
AH
RE
AH
AH
P
A
D
