find a string in a json

According Doctrine ORM documentation you should to use something like:

$qb->select('*')
   ->from('er', 'er')
   ->where('JSON_CONTAINS(er.errors, :error) = 1')
   ->setParameter('error', '{"message": "find_this_message"}'); 

MySQL JSON_CONTAINS online

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top