021
Well-known member
.ability to use
I also suggest using JSON or TEXT type in tables instead of BLOB.
$finder->where('metadata->something', '=', 'wow')
instead of
PHP:
$expression = $finder->expression(
sprintf(
'json_unquote(json_extract(%s, \'$."%s"\')) = %s',
$finder->columnSqlName('metadata'),
'something', $finder->quote('wow')
)
);
$finder->where($expression);
I also suggest using JSON or TEXT type in tables instead of BLOB.
Upvote
0