Im trying to fetch some datas depending on the JSON column meta
. However, something weirds happen around the ->
symbol.
File::whereJsonContains('meta->serie', 'value')->toSql();
output
"select * from `files` where json_contains(`meta`->'$.\"serie\"', ?)"
Here is the error I get
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '>'$."serie"', ?)' at line 1 (SQL: select * from
files
where json_contains(meta
->'$."serie"', "check_up"))
I tried using a regular where
but it throws the same error. Any idea?
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire