Good morning all of you, it’s 6AM here and very cold
Does anybody know if we can perform a find in a field that is a json array ?
The array contains a list of numbers :
I could not manage to use JSON_CONTAINS or JSON_SEARCH
It is a json array stored in a Mysql table;
I tried a standard find method :
$this->Documents->find()->where([‘Documents.readers JSON_CONTAINS’ => n])
where n can be any number