mysql - How to filter elements with json contains ? then createQueryBuilder

Question

I work on symfony with calls or createQueryBuilder I have a table like this one

+----+--------------+
| id | langs        |
+----+--------------+
|  1 | ["EN", "ES"] |
|  2 | ["ES"]       |
|  3 | ["EN", "FR"] |
|  4 | ["ES"]       |
+----+--------------+

Already understand the Query query before trying to translate it, I would like to make an order in this style ?

SELECT * FROM `project` WHERE JSON_CONTAINS(data?,'"FR"');

I would like a return like this

+----+--------------+
| id | langs        |
+----+--------------+
|  3 | ["EN", "FR"] |
+----+--------------+

If you have solutions for me, thank you

question from:https://stackoverflow.com/questions/65836502/how-to-filter-elements-with-json-contains-then-createquerybuilder

Answer 1

Waitting for answers