QGIS MySQL points import

I have a column in my MySQL database table that contains location information (GeoJSON).

I want to import this data and see the points on my QGIS project map but it doesn’t seem to work.
What I was trying to do:

Layer -> Add Layer -> Add Vector Layer -> Database -> insert the server configuration -> Add -> import the relevant table.

EDIT:

I missed the query. I used the query builder and it seems to find around 200 relevant rows, but it shows only 1 point on the map. In addition, the point is not in the right spot…