SQL - PHP SYMFONY 4 - QUOTE
I want to interrogate my BD which includes a Json field.
When I test my request in phpmyadmin (sql) everything works but in php (symfony 4) I have a quote problem I think.
Here is my request
$sql = " SELECT * FROM myTable WHERE user_id = :userId AND JSON_CONTAINS(roles, '["ROLE_FOO"]') ";